Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18
How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.
Answer Posted / kumar
source seq file is connected to transformer stage and take
three out links connected to three data sets
in transformer stage under constraints by using Mod
Function we can acheive the result for N number of records
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
which r the connectors used in san?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is the precedence of stage variables,derivations, and constraints?
What is datastage engine?
What is the purpose of pivot stage?
How many Key we can define in remove duplicate stage?
What is meta stage?
What are the enhancements made in datastage 7.5 compare with 7.0?
Where do you see different stages in the designer?
What is the project in datastage?
What is the importance of the exception activity in datastage?
Define meta stage?
What is the process of killing a job in datastage?
How will you move hashed file from one location to another location?
Difference between ‘validated ok’ and ‘compiled’ in data stage?