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
What do you know about partition and also tell us about partition components in abinitio?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
How can you import XML repositories exported from different tools like ODI
What is a deadlock and how it occurs?
Mention some file extensions which are used in abinitio?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
Explain what is the architecture of abinitio?
How to add default rules in the transformer?
What exactly do you know about the typical data analysis?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What is publickey and private key?what is the use of this two keys?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
What is the architecture of abinitio?