How can you join flat file, oracle as a sources?
Answer Posted / vijay
First you convert the data from flat file into oracle , so
now we have two oracle db's then easily we can join these
two sources using join stage.
I have also faced this question at IBM US.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are the various kinds of the hash file?
Explain datastage architecture?
How to perform incremental load in datastage?
What is ibm datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the types of containers in datastage?
how to sort two columns in single job in datastage.
Describe link sort?
What is the sortmerge collector?
Why do we use link partitioner and link collector in datastage?
What is oci?
What are the functionalities of link collector?
What is the different type of jobs in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
How to clean the datastage repository?