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
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the command line function to import and export the ds jobs?
What is the use of hoursfromtime() function in transformer stage in datastage?
How and where you used hash file?
How we can covert server job to a parallel job?
How do y read Sequential file from job control?
What is the roundrobin collector?
What are the benefits of datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is a merge?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
why do u need the IOS upgradation in a FC switch
Is it possible to query a hash file?
Explain Quality stage?