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

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3033


Explain connectivity between datastage with datasources?

776


What is the difference between an operational datastage and a data warehouse?

859


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4827


What is a quality stage in datastage tool?

836


What are orabulk and bcp stages?

868


What are the functionalities of link partitioner?

809


explain about citrix scheduling tool in datastage

2070


What is the difference between datastage and informatica?

848


What is the use of hoursfromtime() function in transformer stage in datastage?

800


What are the enhancements made in datastage 7.5 compare with 7.0?

921


What is usage analysis in datastage?

1045


How do you remove duplicate values in datastage?

849


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3209


how to export or import the jobs in .ISX file

946