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
Which algorithm you used for your hashfile?
Describe stream connector?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Enlist various types of routines in datastage.
What are orabulk and bcp stages?
How do you generate sequence number in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the importance of the exception activity in datastage?
Which commands are used to import and export the datastage jobs?
How do you import and export the datastage jobs?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the difference between datastage and datastage tx?
What are the repository tables in datastage?
in oracle target stage when we use load option and when we use upsert option?
What is process model?