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
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is use Array size in datastage
Distinguish between informatica & datastage. Which one would you choose and why?
Differentiate between odbc and drs stage?
Define orabulk and bcp stages?
how can we create rank using datastage?what is the meaning of rank?
What is the roundrobin collector?
How to implement complex jobs in data stage?
How the ipc stage work?
Explain datastage architecture?
How do you find the number of rows in a sequential file?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the purpose of pivot stage?
How to convert RGB Value to Hexadecimal values in datastage?
Describe routines in datastage? Enlist various types of routines.