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
What is orabulk stage?
What is a quality stage in datastage tool?
What is the different type of jobs in datastage?
What are the different plug-ins stages used in your projects?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
On which Dimension Table you implemented SCD Type in your Project
how to delete one row in target dataset
Is possible to create skid in dim,fact tables?
In Datastage, how you can fix the truncated data error?
What are the types of containers?
What could be a data source system?
What is the difference between informatica and datastage?
Can you explain repository tables in datastage?
What are constraints and derivations?
I have a few records just I want to store data in to targets cycling way how?