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
Terminate Activity
What is "fatal error/rdbms code 3996" error?
Define ds designer?
how to write server Routine coding?
How will you move hashed file from one location to another location?
What is the roundrobin collector?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is datastage engine?
What are the different layers in the information server architecture?
How do you register plug-ins?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the components of datastage?
What are the processing stages?
What is orabulk stage?
What are the some differences between 7.x and 8.x version of datastage?