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 are the steps needed to create a simple basic datastage job?
how to validate the jobs
Highlight the main features of datastage?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
what is a force compile
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
how many rows sorted in sort stage by default in server jobs
how many types of sorting the data in data stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?