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 |
Difference between public and private projects and how to make private to public?
What are the six data process products of ab initio (architecture of ab initio)?
Can sorting and storing be done through single software or you need different for these approaches?
What parallelisms does Abinitio support?
After completion of graph what is the next process to perform? who will perform the later process?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
What are the different versions and releases of ABinitio ?
How transaction file different from that of a sort file?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
Describe the grant/revoke ddl facility and how it is implemented?
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 function that transfers a string into a decimal?