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 the different plug-ins stages used in your projects?
How many Key we can define in remove duplicate stage?
Explain the situation where you have applied SCD in your project?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are system variables and sequencers in datastage
what is ds administrator used for?
What is merge stage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the difference between datastage and datastage tx?
What is apt_config in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the stages in datastage?
Could anyone give brief explanation bout datastage admin
