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 options associated with dsjob command?
in oracle target stage when we use load option and when we use upsert option?
Is possible to create skid in dim,fact tables?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How to RD using transformer?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Describe the main features of datastage?
Differentiate between validated and Compiled in the Datastage?
How to read the length of word in unix?
What is the difference between in process and inter process?
Can you explain engine tier in information server?
What is the difference between server job and parallel jobs?
How can you write parallel routines in datastage PX?
What is use Array size in datastage
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
