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 / 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 to move or copy the project parameter or project object to my sandbox?
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
What is .abinitiorc and What it contain?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
Can you explain the performance and scalability of co> operating system?
How can we increase the loading performance of oracle table in AbInitio?
What is the best way of creating huge test feeds ? How to use in abinitio graph?
How you can delete an object from a tag ? How to use in abinitio graph?
) Diff.between Output index and Output indexes?
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
) Layout? What is the Dataset & Program Component Layout
Can any body give the PDL with example?