What is the usage of .mfctl and .mdir files in the mfs directory of Ab Initio?

biyyanimv

 Profile Answers by biyyanimv Questions by biyyanimv

• Mar 8th, 2009

.mfctl and .mdir are both related to multifile system. .mfctl extension of control file created when we are using the MFS. The file extension .mfctl will contain the URLs of all the data partitions. The file with the extension .mdir will contain the URL of the control file used by MFS

Answer Question  Select Best Answer

What are Wrapper scripts? What does it contain?

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Jul 19th, 2010

Wrapper scripts are unix scripts,they also known as calling scripts.they used to run the deployed scripts.in the order what se can specify in the unix script

Answer Question  Select Best Answer

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 23rd, 2010

.pset file is an input values or input parameters set file. By using the air sandbox run command we can run the .pset file. Internally calling the .mp file and passing all the inputs parameter during run time.--Shambhu

Answer Question  Select Best Answer

naveen

• May 15th, 2006

$#  - No of positional parameters$? - the exit status of the last executed command.

cndraa

• May 13th, 2006

Then what is $# and $? ...

Answer Question  Select Best Answer

sreenivasamurthy

 Profile Answers by sreenivasamurthy Questions by sreenivasamurthy

• Jun 20th, 2007

Normally to maintain short term historical data llike 3-6 months etc. there is no need to go to DWH. For maintaining long ternm historical data i.e., 3-6 years etc., You need to go to DWH. In DWH we w...

ankur

• May 26th, 2007

We can have active and inactive records in data warehouse to maintain history.

Answer Question  Select Best Answer

How do we append records to an already existing file usin abinitio graph?

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Apr 2nd, 2010

if you want to append the record to same out put file just  go to acess in properties window there you will find the option s uncheck the option "delete file if tits exit" and check the...

Mihira Barik

 Profile Answers by Mihira Barik Questions by Mihira Barik

• Nov 9th, 2009

Create a graph by taking the existing file as?the out put file and keep the mode of the output file in Append Mode. Pass the?new records from the input file?to this?output file through a?reformat. This will append new?records in the existing File.

Answer Question  Select Best Answer

seemabuchhada

 Profile Answers by seemabuchhada Questions by seemabuchhada

• Mar 15th, 2014

In most cases you are unloading enough data to require a parallel unload. Adding the ABLOCAL(tablename) clause to your SQL statement prevents the Input Table component from parsing the SQL and specifi...

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Oct 27th, 2010

The use of ABLOCAL() construct is in Some complex SQL statements contain grammar that is not recognized by the Ab Initio parser. When data is unloading in parallel.  Then ABLOCAL() construct ...

Answer Question  Select Best Answer

How to delete a record from a multifile?

Sandeep

• Sep 10th, 2017

Linux command:
vi `m_expand -native file_name`
it will expand the control file and allow us to edit in all partition.

SP

• Jun 5th, 2017

a. Build a duplicate graph with the same logic that processes the file b. Select Never Abort for that component where a failure may occur. c. Arrange Reject port for that component and run the grap...

Answer Question  Select Best Answer

What is Interpretation in Abinitio? What are types of interpretations available and its uses? Where do we use each interpretation?

Sandeep

• Mar 25th, 2018

Constant,$substitution,${}substitution,PDL

KV

• Mar 7th, 2018

Types of interpretation- PDL, Shell, Substitution

Answer Question  Select Best Answer

Satish Kumar

• Jun 9th, 2007

Hi Praveen,In Ab Initio there is no In Built Schedular in the GDE...Most of them are using cron tab or specific tools for scheduling 1)AutoSys or2)Maestro.

ramu

• Feb 19th, 2007

You dont have schedule in abinitio unlike informatica here in this tool we need to buy the third party tool namely autosys for scheduling

Answer Question  Select Best Answer

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew Questions by abhi_fresh_as_dew

• Feb 3rd, 2010

For ASCII formats write the DML as below.cust_id decimal(8)...For EBCIDIC formats write the DML as below.ebcidic cust_id decimal(8)...The delimiters varies in each and every ebcidic formats send from source files.  But Its generally hexadecimal embedded.

AprilBlue

 Profile Answers by AprilBlue Questions by AprilBlue

• Jan 10th, 2007

Ascii vs. EbcdicWhen you view  your data does it have different charaters inbetween that do not look ASCII?  If so, then in your record format type the following:ebcdic record record details...

Answer Question  Select Best Answer

How do you do production support for Graph? How do you check whether graph is completed successfully or not (is it $? of unix?)What are different return values?

sham2sushil

 Profile Answers by sham2sushil Questions by sham2sushil

• Apr 27th, 2010

If you running the Abinitio ksh file then you have to check the status using $? .$mpjret is using in  the end script of the abinitio to check the abintio mp runs sucessfully or not.--Shambhu

sitharaju

 Profile Answers by sitharaju Questions by sitharaju

• Mar 11th, 2009

How do you do production support for Graph? If the graph failed in the production, usually we get emergency access to see the failure, then analyse the failure, if it is a code bug, then we go back to...

Answer Question  Select Best Answer

How to use rollup Component as Scan Component? On what condition Rollup component can be used as SCAN?

Jatin

• Apr 30th, 2018

Rollup will produce same number of columns as scan only in case when all the columns are selected as rollup key

Speedy

• Sep 22nd, 2017

As per my understanding, we cannot use rollup component as a scan component. The reason for this is Scan gets the cumulative data and can process the same number of output records as the number of inp...

Answer Question  Select Best Answer

How to generate sequence number in a multifile using next_in_sequence().

Sachin

• Feb 3rd, 2016

Next_in_sequence()*(this_partition()+1)

srinivasareddy

• Jul 21st, 2015

hi I think this will be help you if the mfs is 4-way if (this_partition() == 0)((next_in_sequence()-1))+this_partition()+1 else if (this_partition() == 1) ((next_in_sequence()-1))+this_partition(...

Answer Question  Select Best Answer

I have a record like below:
avi,mahi,virat,mahi,avi,virat,mahi,virat,avi
Output should be:
avi1
mahi1
virat1
mahi2
avi2
virat3
mahi3
virat4
avi3
Please suggest how can I achieve this.

neha.nagare

 Profile Answers by neha.nagare Questions by neha.nagare

• Apr 26th, 2018

Flow I/p ->normalize ->scan->o/p We can achieve this by using normalize and scan component ,make vector by using string_split function and assign size of the vector to the length function of the no...

Sandeep

• Mar 25th, 2018

Use scan component using check sort attribute as false(maintain order-false)
then use name as key and for sequence number use count(in.name)

Answer Question  Select Best Answer

veer

• Jul 17th, 2023

Rollup Summarizes data by grouping records and applying an aggregate function to each group. The finalize transform function is applied to a group of records to produce an output record. The number...

kalyanvadlamudi2kn

 Profile Answers by kalyanvadlamudi2kn Questions by kalyanvadlamudi2kn

• Jan 8th, 2014

Roll up: Scan: Aggregate Summary Cumulative Sum...

Answer Question  Select Best Answer

I have data like below.
source file:
EmpID sal
A 1000
B 2000
C 3000
D 4000

Lookup File
EmpID
A
B

Output File
EMPID Sal
C 3000
D 4000

I want empId, sal of employees those not present in lookup file

saigoud

• May 16th, 2017

Use the components lookup and Filter_by_expression and write the code
lookup_count("Lookup File",empid)==0 in FBE you will get this output

Garima Takur

• Nov 27th, 2016

Use FBE component and give he select condition as !(lookup_match("lookup_file",in.emp_id) the output in select port will be the required result

Answer Question  Select Best Answer

saran

• Sep 4th, 2011

EME is a repository in Ab Inition and it used for checkin and checkout for graphs also maintains graph version. There will be lock put once it is access by any users.

surendra

• Aug 8th, 2011

By using command line prompt. We have AIR COMMANDS for Check In & Check Out Process

Check In : air project import/project// - base dir /ai/src//users/dev//sand/ -files

Answer Question  Select Best Answer

How can we fetch next record data for a particular field in ab initio?
i/p
id sal
101 500
102 800
103 900
105 200
o/p
id sal Pre_sal
101 500 0
102 800 500
103 900 800
105 200 900

Sai

• May 14th, 2018

use scan component we have to achieve this scenario and the parameter key is "NULL({})"and find the below explanation.Here i am taking the 2 temporary variables as a,b. type temporary_type = record ...

neha.nagare

 Profile Answers by neha.nagare Questions by neha.nagare

• Apr 26th, 2018

We can achieve this by using reformat component by maintaining current and previous value of the column sal and by updating variable prev_sal with previous record value of column sal. Please find...

Answer Question  Select Best Answer

How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?

mk_44

 Profile Answers by mk_44 Questions by mk_44

• Feb 9th, 2016

I guess below code can help for 3rd max else 1st max for each group key. Input_file --> sort (descending) --> Rollup --> output type temporary_type=record decimal("") rank ; decimal("") sal ...

disha

• Jan 22nd, 2016

@Dinesh: but it is not taking care of the requirement, i.e. if there is no 3rd record, it should display the first highest sal. In the solution you mentioned it will display the second highest sal.

Answer Question  Select Best Answer