Link Sort or Stage sort better
Posted: Wed Sep 22, 2010 11:32 pm
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..
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..