How do you load 10 different sources with 10 different layouts
to 10 different tables?
Answer Posted / 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 |
Post New Answer View All Answers
What is the method of removing duplicates, without the remove duplicate stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is ds designer?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Can we use target hash file as a lookup ?
CHANGE CAPTURE
What is the purpose of pivot stage and types of containers in datastage
what is the difference between == and eq in UNIX shell scripting?
how to write server Routine coding?
What are some different alternative commands associated with "dsjob"?
What is difference between symmetric multiprocessing and massive parallel processing?
Differentiate between Join, Merge and Lookup stage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How many types of views are there in a datastage director?
What are the different types of lookups in datastage?