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
Where the datastage stored his repository?
What is the difference between Datastage 7.5 and 7.0?
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?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the enhancements made in datastage 7.5 compare with 7.0?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
table actions available in oracle connector?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
EXPLAIN SCD
what is flow of project?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the different types of lookups in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is the purpose of interprocessor stage in server jobs?
How many types of stage?