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 |
how can u handle null values in transformer stage.
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Differentiate between data file and descriptor file?
How do you run datastage job from the command line?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the functionalities of link collector?
What are some prerequisites for datastage?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
What is meta stage?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?