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
What are the various kinds of the hash file?
How a source file is populated?
Have you have ever worked in unix environment and why it is useful in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the different plug-ins stages used in your projects?
Why do we use exception activity in Datastage?
What is the use of datastage designer?
Differentiate between datastage and datastage tx?
What are the areas of application?
Define Job control?
How do y read Sequential file from job control?
Have you used Unstructured data?
What are stage variables and constants?
Differentiate between Join, Merge and Lookup stage?
Define Data Stage?