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 different layers in the information server architecture?
What are the differences between datastage and informatica?
What are the repository tables in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How can one find bugs in job sequence?
What is a ds designer?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Differentiate between operational datastage (ods) and data warehouse?
What are the various kinds of containers available in datastage?
what is the use of materialized view?
Highlight the main features of datastage?
Differentiate between hash file and sequential file?
How and where you used hash file?
How do y read Sequential file from job control?
What are the stages in datastage?