How do you load 10 different sources with 10 different layouts
to 10 different tables?
Answer / ankit gosain
Hi All,
Simply take 10 seqential files and map it to 10 targets in
your canvas.
like:
seq1------>tgt1
seq2------>tgt2
seq3------>tgt3
--------
--------
--------
seq10----->tgt10
and define the source and target metadeta as you do
normally. now this job independently can load 10 different
sources with 10 different targerts.
For more queries, mail me on ankitgosain@gmail.com
Cheers,
Ankit :)
| Is This Answer Correct ? | 3 Yes | 2 No |
What is ibm datastage flow designer?
how many types of remove the duplicate records?
what r the sources u need to create the datastage?
Why fact table is in normal form?
how to abort the job its matain duplicates?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
How do you start developing a datastage project?
is it possible to access the same job by two users at a time in DataStage?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
What is the difference between Link collector and Funnel Stages?
what is the main differences between Lookup, Join and Merge stages?