-
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 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 -
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 -
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 -
Compare records using scan
I have 3 records . need to compare them fields by fields if there is no change oldest records must go to o/p else if there is change eg if record 2 has changed wrt to record 1 need to send both records to o/p . how to do this using scan component
-
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? -
Write multiple files
Create n output files with 2000 records each if we have 10000 or 20000 records as input
-
-
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? -
Uniqe record.
I have an input file like below.
source|target|dist
BNG|CHN|150
CHN|BNG|150
PUN|MUM|200
MUM|PUN|200
HYD|KOL|1700
KOL|HYD|1700
How can I get uniqe record.
source|target|dist
BNG|CHN|150
PUN|MUM|200
HYD|KOL|1700 -
-
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? -
Scenario Based question
Hi All,
This is the I/p
customer item1 item2
A null 100
A 200 null
B null 300
B 400 null
desired o/p will be as below
A 200 100
B 400 300
Please help 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 Interview Questions
Ans