Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 10 Answers
- 17073 Views
- Polaris, I also Faced
- E-Mail Answers
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
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the different kinds of views available in a datastage director?
If you want to use a same piece of code in different jobs, how will you achieve this?
I have a few records just I want to store data in to targets cycling way how?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is a datastage job?
How rejected rows are managed in datastage?
CHANGE CAPTURE
What is the difference between passive stage and active stage?
Describe the architecture of datastage?
Define APT_CONFIG in Datastage?
Where the datastage stored his repository?
What are the different plug-ins stages used in your projects?
how to write server Routine coding?
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
