my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?
Answer Posted / varaprasad
as for as i know,it is simple task only,
order is seq_file->column_generator->tfx->connect 4 targets.
in CG take one more column as SNO(anything)and goto extended column properties- take value=1,value=2,,,upto 4. now write constraint in tfx sno=1 goto t1
sno=2 goto t2...for all targets(4).
if u get other tahn this pls post answer
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What are the important features of datastage?
in oracle target stage when we use load option and when we use upsert option?
How to reverse the string using SQL?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is size of a transaction and an array means in a datastage?
Differentiate between validated and Compiled in the Datastage?
What is the difference between the local container and shared container?
What are the features of datastage flow designer?
What is a merge in datastage?
What is the precedence of stage variables,derivations, and constraints?
What are the steps required to kill the job 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
What are the enhancements made in datastage 7.5 compare with 7.0?
What is aggtorec restructure operator?
If you want to use the same piece of code in different jobs, how will you achieve it?