How to Concatenate Data from active stages in server 6.0

Amit_111 · Post by **Amit_111** » Tue Mar 27, 2007 2:49 am

I am using Datastage server 6.0 version. I have to concatenate data coming from two transformer stages in a sequential file. But I cant use MERGE or LINK COLLECTOR stage as these are active stages and two continous active stages are not supported.
Please suggest which stage to use. Is there any stage in DS server 6.0 similar to FUNNEL stage as present in Parallel version???

ray.wurlod · Post by **ray.wurlod** » Tue Mar 27, 2007 6:52 am

You can put a sequential file stage or IPC stage between two active stages to overcome the "no active to active" rule.

Amit_111 · Post by **Amit_111** » Tue Mar 27, 2007 8:42 am

Yes...I have that option.....But I have to do this in around 50 Jobs so I will have to add 2 Temporary files in each of these job which will not be of use also after the link collector stage there will be another (target) sequential file. At the end i will have 150 files out of which 100 are of no use and the end user is not ready for this solution. Please can you think of some other solution...........

DSguru2B · Post by **DSguru2B** » Tue Mar 27, 2007 8:57 am

Or just turn on inter process buffering from the job properties.

Amit_111 · Post by **Amit_111** » Thu Mar 29, 2007 6:15 am

Can you please explain the above point in detail....I didnt get your point.

Thanks in Advance.

DSguru2B · Post by **DSguru2B** » Thu Mar 29, 2007 6:43 am

Go to job properties, in the Performance tab, uncheck Use Project Defaults, check Enable row buffer with option Inter process.