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
- 8312 Views
- I also Faced
- E-Mail Answers
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
What is the difference between rollup and scan?
Have you ever encountered an error called “depth not equal”?
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
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
What exactly do you understand with the term data processing and businesses can trust this approach?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
What is ab initio enterprise meta>environment (eme)?
In abinitio, what types of parallelism are used?
What does edp stand for?
Mention what is rollup component?
What the difference between “look-up” file and “look is up” in abinitio?
Define ramp limit in ab initio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Mention some file extensions which are used in abinitio?
