DSXchange

I have tree tables (~10M row/table, 1k/row),
Is it better performance to use a merge stage in DS and send output to a DataSet or do a DB2 table join and fetch result to the DataSet?
The final DataSet should have ~ 9M rows

Thank for your advice

performance wise merge and join are almost the same..if you want the rejections as well u have to with merge..or else..both behave in the same way..

dtv2002 wrote:I have tree tables (~10M row/table, 1k/row),
Is it better performance to use a merge stage in DS and send output to a DataSet or do a DB2 table join and fetch result to the DataSet?
The final DataSet should have ~ 9M rows

Thank for your advice