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
- 1 Answers
- 8533 Views
- I also Faced
- E-Mail Answers
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 |
) Diff.between Output index and Output indexes?
Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio?
Can you read multiple input files using one input file component ?(same DML)
How to move data from developement to testing and testing to production?
1 Answers BitWise, CTS, Satyam, Wipro,
What is the diff between abinitiorc and .abinitiorc files ?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Mention what is the syntax for m_dump in abinitio?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What is data mapping and data modelling?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
What is the difference between check point and phase?
Mention what is rollup component?
Teradata 
