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
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is difference between symmetric multiprocessing and massive parallel processing?
How and where you used hash file?
Differentiate between validated and Compiled in the Datastage?
What are routines in datastage?
How the ipc stage work?
what is the use of materialized view?
What is the difference between in process and inter process?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Why do you need stage variables?
What are the types of containers?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How many types of views are there in a datastage director?
Does datastage support slowly changing dimensions ?