Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amit trivedi
We need to use external tables to join a flat file and oracle table.
First insert all records of flat file into an external table and then join these two tables.
else, use next step, insert data from external table to oracle table and join these two tables using join conditions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are some prerequisites for datastage?
Is possible to create skid in dim,fact tables?
what is repositery?
What are the different options associated with dsjob command?
Explain entity, attribute and relationship in datastage?
options available in sequence job to run,validate?
how can we create rank using datastage?what is the meaning of rank?
What is difference between server jobs & parallel jobs?
whom do you report?
Difference between data warehousing and olap?
Define ds designer?
What is a datastage job?
How to read multiple files using a single datastage job if files have the same metadata?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
