With out using Funnel Stage, how to populate the data from
different sources to single target
- 12 Answers
- 23867 Views
- Wipro, I also Faced
- E-Mail Answers
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
How to RD using transformer?
Notification Activity
Can you implement SCD2 using join, transformer and funnel stage?
Define project in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the difference between operational data stage (ods) and data warehouse?
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
On which interface you will be working as a developer?
What are transforms and what is the differenece between routines and transforms?
What is the process of killing a job in datastage?
What is the difference between the local container and shared container?
What is the difference between validated and compiled in the datastage?
How can we improve the performance in datastage?
Could anyone give brief explanation bout datastage admin
What all are the different way to run a job?
