-
Fetch Next Record Data
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 Next_sal
101 500 800
102 800 900
103 900 200
105 200 NULL -
How to achieve the below scenario in abinitio
Input file has below contents:
Ball Run
1 1
2 1
3 1
4 1
5 1
6 1
1 0
2 1
3 1
4 1
5 1
6 1
1 1
2 1
3 1
4 1
5 1
6 0
Required Output :
1 6
2 5
3 5 -
Eliminating Header and Trailor without using next in sequence and Dedup sort
I have header and trailer records to some body records like below
emp.dat|12042016
1/A/1000
2/B/2000
3/C/3000
3
Here there is no record indicator.
How will you eliminate and separate header and trailer records without using Next In Sequence, Dedup sorted and any Partition components? -
How to convert single row to two columns
Hi,
I have a data like 1,a,b,c,2,d,e,f,g
required output is in two fields:
field1,field2
-----------------
1,a
1,b
1,c
2,d
2,e
2,f -
Pulling out the records which are same in two records
I have two files and I want to compare those two records ,after comparing I want to pull out the records which are same in both records and I want the new record from the unmatched records
record format is like this:
decimal(3) CUST_ID;
string(6) CUST_NAME;
string("
") ADDRESS;
same for two files;
and... -
-
Format Output with Line Breaks
I have input like 1,2,3-7,8,9 How to generate output like below
1
2
3
4
5
6
7
8
9 -
Over vs Runs -- same sequence number for each group
I am having input column as runs with values
3
2
4
6
0
1
0
3
2
6
0
0
4
1
1
2
3
In output I want over number on Over column and corresponding runs on Runs column
Expected o/p is:-
Over Runs
1 2
1 4
1 6
1 3
1 0
1 1
2 0
2 3 -
Scenario
I have customer details as below,
cust_card_no item amount
10001 pen 10
10001 copy 20
10001 pen 10
10001 copy 20
10001 copy 20
now my question is to find the distinct count of item per customer and total ammount spend by a customer? -
To get only Not NUll Values
Suppose I have a scenario like below:
Input:
======
Id Col1 Col2
a 100 Null
a Null 200
b 300 Null
b Null 400
And I need output as:
Output:
=======
Id Col1 Col2
a 100 200
b 300 400
How to get only Not NUll Values? -
-
Data from 1 Column to be separated in Multiple Columns
Input file
col1
1
2
3
4
5
6
7
8
output file
col1 col2 col3 col4
1 2 3 4
5 6 7 8
How to achieve this? -
-
How to convert rows into columns and column into rows in abinitio
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
-
Process 1TB Data and get Max age for each gender group
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? -
How to Convert 4 way mfs to 2 way mfs
how to Convert 4 way mfs to 2 way mfs ....can anyone tell me clear how to do with example
-
Abinitio:.air-lock file and .project.pset
Explain what .air-lock file is?
What is the difference between .sandbox.pset and .project.pset and the need of .project-start.ksh and .project-end.ksh -
Pick the Delta Data From Specific Files or Tables
If I run the graph at 9 O'clock, it should pick the data with the latest updated timestamp records like from 8 to 9 O'clock updated records from the table. How to pick the delta data from specific files or tables?
-
-
Why go for sort within groups?
We have sort and sort within groups components. we can achieve the sort within group functionality by placing two keys in sort group. Then why we have to go for sort within groups?
Abinitio Interview Questions
Ans