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
Differentiate between Join, Merge and Lookup stage?
Explain how a source file is populated?
How complex jobs are implemented in datstage to improve performance?
What is the difference between datastage and datastage tx?
Describe the main features of datastage?
What all are the different way to run a job?
Can you explain players in datastage?
Can you filter data in hashed file?
How a routine is called in datastage job?
Define meta stage?
How many areas for files does datastage have?
How to manage date conversion in Datastage?
How rejected rows are managed in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How many Key we can define in remove duplicate stage?