Change Capture with 1.5 million rows
Posted: Thu Feb 12, 2009 10:10 am
Hi all,
I've never used the Change Capture stage in a PX, but I know that it can be used to extract the differences between two tables, in particular the T1-T2 (probably it would need to run twice, T1-T2 and T2-T1, to get all the differences). What about performances? I had to check whether or not I can use this stage for two compatible tables with even 1.5 million rows, with differences may be of 150 rows only. Do you think it's reasonable to use this stage in this case?
Thanks,
Marco
I've never used the Change Capture stage in a PX, but I know that it can be used to extract the differences between two tables, in particular the T1-T2 (probably it would need to run twice, T1-T2 and T2-T1, to get all the differences). What about performances? I had to check whether or not I can use this stage for two compatible tables with even 1.5 million rows, with differences may be of 150 rows only. Do you think it's reasonable to use this stage in this case?
Thanks,
Marco