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 / venkatesh
the flow is like this
source---->transformer-------->t1
----------->t2
-------------->t3
------------------>t4
in transformer create a stage variable to calculate mod value
mod(input,4) | mod_value
_________________|____________
in constrain write the condition as
mod_value =1 for t1
mod_value=2 for t2
mod_value=3 for t3
mod_value=0 for t4
try this u will get the required o/p
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is usage analysis in datastage?
What are the functionalities of link partitioner and link collector?
What is the difference between validated and compiled in the datastage?
Where do you see different stages in the designer?
What are the different layers in the information server architecture?
Explain the importance of surrogate key in data warehousing?
What is the difference between the local container and shared container?
What is the process of killing a job in datastage?
Differentiate between odbc and drs stage?
What are the main features of datastage?
What are the important features of datastage?
What are stage variables and constants?
how to abort the job its matain duplicates?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How can we improve the performance in datastage?