Multiple links to the same sequential file

[johnno888]

I am trying to write a sequential file with nultiple links without success using DataStage 6. For each row of the input sequential file I need to write out 6 rows to a single output file. These rows are all the same total length, but with differnet record layouts. I have played around with various possibilities and can't get it to work.

Any assistance would be greatly appreciated. I have also sent this problem off to the Ascential Tech Support who are looking at it for me and will post back any results I get.

Thanks
Johnno

 

[JGirl]

I think you could achieve this a lot easier using a datastage subroutine, rather that a job. (Provided that I understand what you are trying to achieve).

From my understanding, you have

--> Output 1
--> Output 2
Seq Input File --> Transformer --> Output 3
--> Output 4
--> Output 5
--> Output 6

and want each of the 6 output links from the 1 transformer stage to be written to a single file.

J

 

[johnno888]

Thank you all for your help, and I'm sure over time I will try out all of the suggestions given.

The Ascential Tech Support offered: "...re-engineer the job, this time making use of the Link Partitioner and Link Collector in order to get the desired results.".

But after playing around, the simplest solution I found was to write each required output row to an output column and then use the Pivot stage to flip these around to rows.

Hope this may help someone out in the future.

Cheers
John