With out using Funnel Stage, how to populate the data from
different sources to single target
Answer Posted / vijay
Hi Kiran ,
We can populate the sources metadata to target without
using funnel stage using "Seqential File" Stage.
let me explain
In Sequential file we have a property called "File" so first
u give the file name and load the data.
Next time in the same sequential file right side we have a
property "File" just click on that so it will ask another
file name just give other file name ...do not load the data
, in the same you can give how many files u have.
Finally u ran the job Automatically the data will be appended.
Thks
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
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 are datastage sequences?
What is the difference between informatica and datastage?
What are the important features of datastage?
root tree will find which is server job and which is parallel job?
What is quality stage?
What are the types of containers and how to create them?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How many Key we can define in remove duplicate stage?
How do you reject records in a transformer?
Can you highlight the main features of ibm infosphere information server?
What is the different type of jobs in datastage?
Describe link sort?
Difference between in process and inter process?