Link Sort or Stage sort better

[vinsashi]

Hi,
In my source i am getting 20,00,000 records in refrence also i have 10,00,000 records.I am using change capture stage for comparing.i have applied link sort for both links(sorting on 4 key columns).which sort better for that.using sort stage or link sort.Please exp why?.I am doing only insert rows.is it good replacing CDC with join...

Thanks
V..

[ray.wurlod]

"Better" using what criteria? My personal preference, documented more than once on DSXchange (did you Search?) is to use an explicit Sort stage because of the extra functionality it provides, chief among which is direct control of memory allocation and the ability to generate key change columns.

CDC and Join perform totally different tasks - the concept of replacing one with the other is anathema.

[madhuker]

For Better performance, use Join Stage which also handles fast sort method.

Thanks & Regards,
Sam