Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join flat file, oracle as a sources?
- 4 Answers
- 12889 Views
- IBM, I also Faced
- E-Mail Answers
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
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
On which interface you will be working as a developer?
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 can we improve the performance in datastage?
why do u need the IOS upgradation in a FC switch
in oracle target stage when we use load option and when we use upsert option?
What is the use of datastage director?
What are the various kinds of the hash file?
Is the value of staging variable stored temporarily or permanently?
What are the different plug-ins stages used in your projects?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Is possible to create skid in dim,fact tables?
What could be a data source system?
How do you run datastage job from the command line?
What are transforms and what is the differenece between routines and transforms?
