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
- 17471 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
Name the different sorting methods in datastage.
How do y read Sequential file from job control?
Why we use surrogate key?
whom do you report?
What is "fatal error/rdbms code 3996" error?
What are the functionalities of link collector?
Lookup constraints
What are the components of ascential data stage?
What is the precedence of stage variables,derivations, and constraints?
Differentiate between hash file and sequential file?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What could be a data source system?
What are transforms and what is the differenece between routines and transforms?
Differentiate between validated and Compiled in the Datastage?
Describe routines in datastage? Enlist various types of routines.
