How can you join flat file, oracle as a sources?
- 4 Answers
- 11144 Views
- IBM, I also Faced
- E-Mail Answers
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
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.
What is size of a transaction and an array means in a datastage?
What steps should be taken to improve Datastage jobs?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How a source file is populated?
What are some prerequisites for datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is the difference between informatica and datastage?
Differentiate between Join, Merge and Lookup stage?
What are the stages in datastage?
What are the some differences between 7.x and 8.x version of datastage?
whom do you report?
What is oci?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Explain ibm infosphere information server and highlight its main features?
