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 is the process of killing a job in datastage?
what is flow of project?
Distinguish between informatica & datastage. Which one would you choose and why?
Define ds designer?
Where do you see different stages in the designer?
What is job control?
Differentiate between hash file and sequential file?
Define repository tables in datastage?
How do you schedule or monitoring the job?
Can you define merge?
Can you explain engine tier in information server?
How a source file is populated?
What are the different kinds of views available in a datastage director?
what is the difference between == and eq in UNIX shell scripting?
How many types of views are there in a datastage director?
