How to handle SCD-1 and SCD-2 ?
Posted: Fri Feb 13, 2009 1:42 am
Hi all,
I'm having three different source tables.In that daily insert update and delete operations takes place.i have to capture these changes
into a single target table.For some tables i'm using SCD-1.and for SCD-2.
So how can i achieve that.
Thanks in advance
I'm having three different source tables.In that daily insert update and delete operations takes place.i have to capture these changes
into a single target table.For some tables i'm using SCD-1.and for SCD-2.
So how can i achieve that.
Thanks in advance