Difference between a phase and checkpoint as far as i know it something related with how temporary files containing the data landed to disk is handled.that is phases are used to break up a graph so that it does not use up all the memory , it reduce the no of component running in parallel hence improves the performances (used for performance fine tuning, by managing the resource in perfect manner)Check...

Mayank

• Dec 28th, 2016

Short answer The essential differences between a phase and a checkpoint are their purpose and how the temporary files containing the data landed to disk are handled: Phases are used to break up a...

preethi

• Oct 16th, 2016

The component immediately before the phase break writes the data into a temporary file in the layout of the component after the phase break

Answer Question  Select Best Answer

How will you convert 8 way mfs to 10 way mfs for multi files?

chandu

• Feb 7th, 2012

We can use re-partition component just like partition by key & sort. In that layout we can change the depth.

AsheshN

 Profile Answers by AsheshN Questions by AsheshN

• Feb 2nd, 2012

We can simply use any partition component (partition by key, round robin or anything) to achieve this. Just Specify the target multi file system location in the layout of the partition component. There you go!!

Answer Question  Select Best Answer

PN Reddy

• Jan 12th, 2012

Yes by using Plans we can make the jobs to run in sequence. means the output of the abc.mp graph is input for xyz.mp. and also by using Autosys or Control M we can schedule the jobs with proper dependencies.

tanuj_06

 Profile Answers by tanuj_06 Questions by tanuj_06

• Jul 9th, 2011

There is something called Conduct IT...Plans where u can schedule multiple graphs in abinitio...

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

M-dump to display record format:m_dump [-dml] [-datafile]

Ashutosh Prasad

• Sep 8th, 2012

M_dump is abinitio utility to view the content of a file[Serial/MFS] in a formatted way.

Syntax :

m_dump

There are other options such as :

-select
-no-print-data
-print-data
-start # -end #
-record
etc..

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

If I have 2 files containing field file1(A,B,C) and file2(A,B,D), if we partition both the files on key A using partition by key and pass the output to join component, if the join key is (A,B) will it join or not and WHY?

Abhishek

• Feb 5th, 2013

Yes, this is going to work fine provided u do it as in-memory. Let me explain why, firstly whenever you are using the field A as a key, for the same data in the both the files, would definitely go int...

vss34

 Profile Answers by vss34 Questions by vss34

• Jul 16th, 2009

The partition key and join key do NOT have to be the exact same.  In order to join properly, you just have to make sure the records being compared are in the same partition.  So if the parti...

Answer Question  Select Best Answer

How does force_error function work ? If we set never abort in reformat , will force_error stop the graph or will it continue to process the next set of records ?

raja

• Feb 9th, 2015

Force_error function will not throw any error when we keep the reject threshold as never abort. but it will reject all unwanted records per requirement and will provide you the message.

shan88

 Profile Answers by shan88 Questions by shan88

• Oct 22nd, 2013

Force error displays the error message upon the failure of the graph,as u r placing never abort, no failure,so no force error.

Answer Question  Select Best Answer

What is max core value? wat is the use of max core?

Ganesh S

• Jan 24th, 2018

Graph will not fail if there is enough space in the disk..max_core is an component in memory where this will be utilized when it is allocated else disk memory will be utilized.

Jyoti

• Dec 29th, 2017

If we change max-core value zero, does component work or fail?
Please provide me explanation.

Answer Question  Select Best Answer

how to Convert 4 way mfs to 2 way mfs ....can anyone tell me clear how to do with example

Mahesh

• May 26th, 2021

Input(4 way) --> (fan in)sort(layout 2 way)--> output( way)
I think this might work

Amaan Sajid Ansari

• Nov 14th, 2018

Gather and repartition, else your graph will throw an error.

Answer Question  Select Best Answer

I have a scenario:
Input file
Col1 col2
1 A
2 B
3 C
4 D

and desired output should be like below:
col1 1 2 3 4
col2 A B C D

Could you please help

jyotiprasad

 Profile Answers by jyotiprasad Questions by jyotiprasad

• Aug 17th, 2017

String_join(Accumulation (in.id),"");
Try this in rollup
Hopefully it works

Jyotiprasad

• Aug 12th, 2017

Use meta pivot or nomalize component

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

Ram

• Jan 9th, 2012

When we say lookup, it can be in serial or it can in MFS and generally based on the application logic we decide what kind of lookup it needs to be. And again we need to think on the natire of the loo...

siva sankar pulivarthi

 Profile Answers by siva sankar pulivarthi Questions by siva sankar pulivarthi

• Dec 28th, 2011

Lookup File should be of small size or less number records. This is because, when the graph is invoked, all the data in the lookup file file will be loaded into memory..This means..if the data in the...

Answer Question  Select Best Answer

venkat_jaksani

 Profile Answers by venkat_jaksani Questions by venkat_jaksani

• Jun 17th, 2010

If string conains the alphanuemica data the decimal-strip will remove the alpanumeric data but the decimal(length) will not remove alphanumeric data.Please let me know If I am wrong.

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Mar 29th, 2010

Decimal_lrepad(string name, decimaldata type length) decimal_lpad(string name, decimaldata type length)

Answer Question  Select Best Answer

shan

• Oct 11th, 2012

M_dump is used to view data as in graphs

m_dump [-dml] [-file]

Nv

• Feb 3rd, 2012

Cat file.dml will work fine but it wont display the record format in a formatted way..You can think of m_dump as "view data in formatted " manner.

Answer Question  Select Best Answer

Ketan Khot

• Jan 12th, 2018

Go with the profile transform. Run your graph with profile transform option to track which statement or function is taking more time so you can updated the code accordingly. Go with graph tracking o...

Mukund

• Dec 28th, 2017

For point no. 2) lookup_local (Which is now replaced with lookup_first_local) can be used efficiently only when data is available in same partition of parent lookup file else it will give NULL results

Answer Question  Select Best Answer

I have 400 records in my in0 file, its 4-way multifile system. How can I find out particular 150th record will goes to which partition using Partition by Key?

Sjn

• Nov 26th, 2020

Hash_value(this_record,key)% no. of output partition = no of output partition for this record

kumar

• Oct 2nd, 2012

Yes, exactly, we can find out by using hash formula.

Answer Question  Select Best Answer

I have a scenario:
Input file
Col1 col2
1 A
2 B
3 C
4 D

and desired output should be like below:
col1 1 2 3 4
col2 A B C D

Could you please help

Sudharshan

• Nov 14th, 2017

1. Use normalize or meta pivot to convert the rows into columns or columns into rows. 2. If you use normalize, set index =2 and then write the below code in normalize function out :: length(in) = b...

sonalika

• Sep 21st, 2017

step 1. use normalize - lenght=2 and set indicator c1 for 1st records and c2 for 2nd records. op would be - c1 1 colum1 column2 c2 A c1 2 c2 B c1 3 c2 C ste...

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

I have 1 TB of record with below format:

CUST_ID
CUST_NAME
GENDER
MOBILE_NO
AGE

I want to fetch max age from each Gender group by only using Reformat component. How to achieve this?

Sohil

• Sep 12th, 2021

Input->sort with Age->Partition By Roundrobin(as 1 TB of data)->Filter By Expression(GENDER==M)->2 Dedup Sort (with select & Deselect port of FBE out) with Key Blank and Keep First -> Concate -> Gather ->output File

Manish

• Jun 24th, 2021

Hi Mahesh, will this solution work if the input data file is a mfs file and we are supposed to run this in parallel?

Answer Question  Select Best Answer

Rajat Singh

• Feb 20th, 2013

Skew of a partition is the amount by which its size deviates from the average partition size

vSudheer

 Profile Answers by vSudheer Questions by vSudheer

• Mar 3rd, 2012

statistically, skew represent distribution of data.. when all partitions share equal amount of data, it is the best use of portioning. This can be achieved by partition-by-roundrobbin or by using equ...

Answer Question  Select Best Answer