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

Define ds designer?

871


What are the types of containers in datastage?

813


CHANGE CAPTURE

980


What are the functionalities of link collector?

724


Have you used Unstructured data?

920






What is the difference between server job and parallel jobs?

793


How many types of stage?

788


On which Dimension Table you implemented SCD Type in your Project

1686


Differentiate between datastage and informatica?

844


I have a few records just I want to store data in to targets cycling way how?

2003


Name the different sorting methods in datastage.

701


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1786


Differentiate between hash file and sequential file?

668


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2023


whom do you report?

1596