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
Describe the main features of datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
what is repositery?
What is datastage?
What are some prerequisites for datastage?
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 is the use of datastage designer?
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
Enlist various types of routines in datastage.
What are the steps needed to create a simple basic datastage job?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How to convert RGB Value to Hexadecimal values in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What could be a data source system?