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
How we can covert server job to a parallel job?
What are routines in datastage? Enlist various types of routines.
What are the functionalities of link partitioner and link collector?
How to clean the datastage repository?
How rejected rows are managed in datastage?
Differentiate between Join, Merge and Lookup stage?
What are the components of ascential data stage?
Lookup constraints
Explain the situation where you have applied SCD in your project?
What are the areas of application?
How many types of stage?
Explain Quality stage?
What is the difference between validated and compiled in the datastage?
What is the purpose of interprocessor stage in server jobs?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?