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
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
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
Name the different sorting methods in datastage.
Define oconv () and iconv () functions in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
what are the devoleper roles in real time? plz tell i am new to datastage....
how to implement scd2 in datastage 7.5 with lookup stage
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is difference between server jobs & parallel jobs?
which r the connectors used in san?
What is a merge?
What is "fatal error/rdbms code 3996" error?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the sortmerge collector?
How to manage date conversion in Datastage?