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 process model?
Can you implement SCD2 using join, transformer and funnel stage?
How will you move hashed file from one location to another location?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are some prerequisites for datastage?
Define oconv () and iconv () functions in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Define Merge?
Describe the architecture of datastage?
Define project in datastage?
What steps should be taken to improve Datastage jobs?
how to abort the job its matain duplicates?
What are the different plug-ins stages used in your projects?
What are the important features of datastage?
Define Routines and their types?