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
Can you explain kafka connector?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Explain the datastage parallel extender (px) or enterprise edition (ee)?
what is repositery?
What are the types of containers in datastage?
What is datastage engine?
What are the different type of jobs in datastage?
What are the different layers in the information server architecture?
root tree will find which is server job and which is parallel job?
What is active and passive stage?
in oracle target stage when we use load option and when we use upsert option?
What is ibm datastage flow designer?
Is the value of staging variable stored temporarily or permanently?
What is difference between join, merge and lookup stage?
Demonstrate experience in maintaining quality process standards?