With out using Funnel Stage, how to populate the data from
different sources to single target
Answer Posted / bharath
Hi kiran,
in one same job you create as follows,
seq1------>tseq1
seq2------>tseq2
step1:load first source into tseq1 as file name tgt.txt
step2:load second source into tseq2 as file name
tgt.txt(ensure file name first file name only)
step3:Give file upload mode=Append
run for one time you will get...
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the flow of loading data into fact & dimensional tables?
What is a merge 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 difference between orabulk and bcp stages?
whom do you report?
How do u convert the columns to rows in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the purpose of interprocessor stage in server jobs?
Have you have ever worked in unix environment and why it is useful in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the components of ascential data stage?
Notification Activity
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the primary usages of datastage tool?