1. Categories >> Software >> Data Warehouse >> Ab Initio
  2. Suggest New Category

Hi friends
i have 3 input files
1 is country file(cid,cname)
2 is State file(cid,sname)
3 is populate file(pid,sid,Adress)
I want (cname & total poplation)
how i can get the output please help me
Thank you

Question Posted / suresh


Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is po..

Answer / pathikrit

Do a join on the 1st File & second file & then with the third file as you have the same key.

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More Ab Initio Interview Questions

Mention what is the role of co-operating system in abinitio?

1 Answers  

Have you ever encountered an error called “depth not equal”?

1 Answers  

What is de-partition in abinitio?

1 Answers  

how can you convert 3 way to 7way partitioning in abinitio?

4 Answers  

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

1 Answers  

how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?

3 Answers   IBM, Syntel,

How Does MAXCORE works?

4 Answers   CTS,

How to add default rules in the transformer?

1 Answers  

Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

1 Answers  

How to migrate the code FROM development to QA and QA to production?

1 Answers   CTS,

What are the reasons for which business can trust the approach of data processing?

1 Answers  

Can you run air sandbox run using pset ?

2 Answers  

For more Ab Initio Interview Questions Click Here
Categories