Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load 10 different sources with 10 different layouts
to 10 different tables?
- 1 Answers
- 7297 Views
- TIAA CREF, I also Faced
- E-Mail Answers
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 APT_DUMP_SCORE?
How do u call shellscript/Batch file from DS?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
What are the components of ascential data stage?
when we will use connected Lookup & Unconnected Lookup
what is the difference between == and eq in UNIX shell scripting?
when will you go for dataset and fileset?
How many types of sorting methods are available in datastage?
what is mapping lookup
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
Teradata 
