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
- 16797 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
What is the difference between informatica and datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are stage variables?
Which commands are used to import and export the datastage jobs?
What is the command line function to import and export the ds jobs?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the process of killing a job in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is active and passive stage?
What are the job parameters?
What is quality stage?
How to convert RGB Value to Hexadecimal values in datastage?
