With out using Funnel Stage, how to populate the data from
different sources to single target
Answer Posted / subhash
1. Parameterise the File name and pass the diff file names
at run time, in the target we can put write mode 'append'
2. We can add multiple 'File' properties in the seq file
stage and give them diff file names and run it.
3. If all files are in same directory, then
File: DirectoryName/*#Date#.txt
and run the job.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how to implement scd2 in datastage 7.5 with lookup stage
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 different type of jobs in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between datastage and datastage tx?
What is job control?
How complex jobs are implemented in datstage to improve performance?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How can we improve the performance in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are some different alternative commands associated with "dsjob"?
Can you explain tagbatch restructure operator?