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
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Explain connectivity between datastage with datasources?
What is the difference between an operational datastage and a data warehouse?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is a quality stage in datastage tool?
What are orabulk and bcp stages?
What are the functionalities of link partitioner?
explain about citrix scheduling tool in datastage
What is the difference between datastage and informatica?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is usage analysis in datastage?
How do you remove duplicate values in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to export or import the jobs in .ISX file