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
what is the use of materialized view?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to delete one row in target dataset
Why we use surrogate key?
How a server job can be converted to a parallel job?
What are the primary usages of datastage tool?
How can we improve performance of data stage jobs?
How and where you used hash file?
What could be a data source system?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are transforms and what is the differenece between routines and transforms?
Can you explain players in datastage?
What are stage variables, derivations and constants?
What is job control?