How do you load 10 different sources with 10 different layouts
to 10 different tables?
- 1 Answers
- 7031 Views
- TIAA CREF, I also Faced
- E-Mail Answers
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 |
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
how do u catch bad rows from OCI stage? And what CLI stands for?
Describe routines in datastage? Enlist various types of routines.
When we will go for Data elements?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
how many write modes are there in ds
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
State the difference between an operational datastage and a data warehouse?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
Teradata 
