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
Answer Posted / 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 View All Answers
How would you find out whether a sql query is using the indices you expect?
What is MAX CORE of a component?
Have you worked with packages?
Where $mpjret is used in ab-initio?
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
Explain how abinitio eme is segregated?
What do you know about partition and also tell us about partition components in abinitio?
How transaction file different from that of a sort file?
How can you import XML repositories exported from different tools like ODI
What is common among data validity and data integrity?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
What is a partition?
What is local and formal parameter?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
Explain what does dependency analysis mean in abinitio?