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

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

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

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

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

jatin

• Apr 30th, 2018

1. In memory components where input not need not be sorted is selected like Rollup,join,scan,
2. Sort component

sonalika

• Sep 21st, 2017

Sort breaks pipeline parallelism

Answer Question  Select Best Answer

How to print the position of the char in a given word

I have a input like:
Column_name:
Indicator
YNNYYN
NNNYYN
YYYYYN
NNNNNN

REQUIRED O/P:
Where the Y is present in a given string, i want position of the string with CONCATENATE of P Letter.

o/p:
P1
P4
P5
P4
P5
P1
P2
P3

shivank b

• Apr 4th, 2021

The simplest solution would be using reformat with below function.
out.data :: string_concat("P",(decimal(1))string_index(in.column_name,"Y"))

Regards,
Shivank B

RR

• Jan 22nd, 2021

How do you define the output format of Reformat here?

Answer Question  Select Best Answer

jakirajam

 Profile Answers by jakirajam Questions by jakirajam

• Jul 25th, 2010

"version it"  institute is not  teaching ab initio course;By jakirajam

jakirajam

 Profile Answers by jakirajam Questions by jakirajam

• Jul 25th, 2010

Hello 2.18.32 is new version for co op and 1.18 is new version for GDE.Ok keep it up . By jakirajam

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

I have 100 records in input file if I run graph first time first 20 records will go to output, in next run 21 to 40 records will go to output, like this in 5th run 81 to 100 records will to output. Please let me know how can I achieve this?

Thanks in advance

siva

• Apr 17th, 2018

Use the Partition by round robin component and set the block size 20

Natrayan

• May 16th, 2017

We can use the Partition by range component to segregate the record based on record number

Answer Question  Select Best Answer

I have a scenario like below:

Date Amt
01-01-2016 100
01-01-2016 300
02-01-2016 350
01-01-2016 200
02-01-2016 150
02-01-2016 400
01-01-2016 250
02-01-2016 250

I want to find top to transactions on each date:

Amaan Sajid Ansari

• Nov 14th, 2018

Use SORT---> SCAN (use scan select function and set the value as < =2)

Krushna

• Sep 7th, 2018

Sort on date and amount(descending) then use scan to assign number within group then filter records whose number

Answer Question  Select Best Answer