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 is the use of datastage designer?
What are the some differences between 7.x and 8.x version of datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
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
Different ways a project can be moved to production ?...example ….export-import and Version control.
How the ipc stage work?
What is apt_config in datastage?
Which warehouse using in your datawarehouse
How you Implemented SCD Type 1 & Type 2 in your project?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How many types of sorting methods are available in datastage?
What is quality stage?
Define meta stage?
What is ibm datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me