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 is difference between symmetric multiprocessing and massive parallel processing?
what is the use of skid in reporting?
Explain datastage architecture?
Can you implement SCD2 using join, transformer and funnel stage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How do you import and export the datastage jobs?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Differentiate between hash file and sequential file?
What are transforms and what is the differenece between routines and transforms?
What are the job parameters?
What is the sortmerge collector?
What are the different types of lookups in datastage?
Terminate Activity
How do you import and export data into datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals