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


Please Help Members By Posting Answers For Below Questions

How to reverse the string using SQL?

888


options available in sequence job to run,validate?

832


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1076


If you want to use a same piece of code in different jobs, how will you achieve this?

787


What are the different common services in datastage?

703






What is orabulk stage?

630


What are the primary usages of datastage tool?

623


What is staging variable?

622


What is the command line function to import and export the ds jobs?

679


Where the datastage stored his repository?

616


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2004


What is the difference between datastage and informatica?

609


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

953


Have you have ever worked in unix environment and why it is useful in datastage?

645


What is the difference between passive stage and active stage?

820