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
- 9277 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
How to add default rules in transformer?
Within a cursor, how would you update fields on the row just fetched?
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?
What is the difference between a scan component and a rollup component?
how to insert/update a csv file by comparing it with another csv file?
What is a look-up?
What do you mean by a transaction file and how it is different from that of a sort file?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What a local lookup is?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What is data encoding?
What are the fundamental blocks of co> operating system of ab initio?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
What do you understand by local lookup?
