How do you load 10 different sources with 10 different layouts
to 10 different tables?



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

Post New Answer

More Data Stage Interview Questions

what is operator combinality in datastage?

1 Answers   TCS,


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,


I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,


How many input links can you give to a Transformer stage?

6 Answers  


What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,






what is the diff between sequential file and fileset stages?

3 Answers  


Explain entity, attribute and relationship in datastage?

0 Answers  


What is mapping?

3 Answers  


How do you get log info into a file?

1 Answers  


If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,


source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,


What is the sortmerge collector?

0 Answers  


Categories