How can you join flat file, oracle as a sources?
Answer Posted / kalyanreddy
Hi Vijay,
first populate flatfile data to orale db
two methods,
1. write a join query in source oralce stage and link to
target.
2. take two oracle sources like s1 and s2 , use join stage
and link to target
or
direct method
3.take flat file and oracle source, use join stage and link
to target.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
In Datastage, how you can fix the truncated data error?
What is the importance of the exception activity in datastage?
What are the various kinds of containers available in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Demonstrate experience in maintaining quality process standards?
What are the different types of lookups in datastage?
What is the difference between an operational datastage and a data warehouse?
What is the difference between the local container and shared container?
client know skid info?
How to read multiple files using a single datastage job if files have the same metadata?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the difference between hashfile and sequential file?
What is size of a transaction and an array means in a datastage?
table actions available in oracle connector?
What are the steps required to kill the job in Datastage?