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
how to implement scd2 in datastage 7.5 with lookup stage
What are the stages in datastage?
How do u convert the columns to rows in datastage?
how to write server Routine coding?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
how to delete one row in target dataset
what is repositery?
What is process model?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is "fatal error/rdbms code 3996" error?
Describe the architecture of datastage?
How to reverse the string using SQL?
How a routine is called in datastage job?
What are the different options associated with dsjob command?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara