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
Can you explain tagbatch restructure operator?
What are transforms and what is the differenece between routines and transforms?
What are orabulk and bcp stages?
Have you used Unstructured data?
What are data elements?
Define data aggregation?
What are the job parameters?
Name the third party tools that can be used in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the various kinds of containers available in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the difference between validated and compiled in the datastage?
I have a few records just I want to store data in to targets cycling way how?
Describe stream connector?
What is the purpose of pivot stage?