Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9280 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 |
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Describe step by step the process of creating tag and savefile for migration
How co> operating system natively processes the data?
what is the difference between ab_work_dir and .work
How do you truncate a table?
what is the difference between i)public ii)private iii)common and client projects?
How to add default rules in transformer?
what is difference between fuse and join? Explain in detail? In which scenario we will use them?
Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?
What is $mpjret?
What is the importance of eme in abinitio?
Teradata 
