How can you join flat file, oracle as a sources?
Answer Posted / bharathd
By using Seqfile stage(flat file) and Oracle(Dynamic RDBMS
stage)to extract the data from sources, the join the data
using join stage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datastage and datastage tx?
Describe stream connector?
Describe the main features of 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.
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
how to implement scd2 in datastage 7.5 with lookup stage
What are the benefits of datastage?
What are the important features of datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the use of datastage designer?
What is data partitioning?
Differentiate between validated and Compiled in the Datastage?
How to Remove Duplicate using SQL?
What are datastage sequences?
How do you schedule or monitoring the job?