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


Please Help Members By Posting Answers For Below Questions

how to implement scd2 in datastage 7.5 with lookup stage

5135


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1810


What are the different type of jobs in datastage?

610


what are the devoleper roles in real time? plz tell i am new to datastage....

1647


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2429






what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

960


What is the difference between datastage and datastage tx?

600


What is job control?

624


How complex jobs are implemented in datstage to improve performance?

604


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1725


How can we improve the performance in datastage?

656


How to convert RGB Value to Hexadecimal values in datastage?

3462


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

369


What are some different alternative commands associated with "dsjob"?

665


Can you explain tagbatch restructure operator?

707