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
Can we use target hash file as a lookup ?
Differentiate between odbc and drs stage?
How can we improve performance of data stage jobs?
What is a merge?
Highlight the main features of datastage?
Can you explain engine tier in information server?
What is a quality stage in datastage tool?
What are the repository tables in datastage?
Difference between server jobs & parallel jobs?
Can you explain link buffering?
Describe the architecture of datastage?
Describe routines in datastage? Enlist various types of routines.
Define oconv () and iconv () functions in datastage?
What is the use of datastage director?
Differentiate between data file and descriptor file?
