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
- 8331 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 |
How does the bre work with the co>operating system?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?
What is EME?What is GDE?What is Co-operating system?What is the link between all these?Please explain elaborately.
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
How can you connect eme to abinitio server?
What do you know about partition and also tell us about partition components in abinitio?
What are the differences between different versions of co-op?
How can you export a component’s internal parameters ?
Have you eveer encountered an error called "depth not equal"?
What is the difference between partitioning with key and round robin?
Explain the difference between the truncate and delete commands?
Teradata 
