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 stage variables?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the various kinds of the hash file?
how do u catch bad rows from OCI stage? And what CLI stands for?
How can we improve performance of data stage jobs?
To see hidden files in LINIX?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Define data aggregation?
What are the important features of datastage?
What are the types of views in datastage director?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the project in datastage?
What is the difference between Datastage 7.5 and 7.0?