Need SCD 2 and SCD 1 logic help
Posted: Fri Nov 04, 2011 11:33 am
Hi,
We have designed SCD-2 model maintaing the history in dimension tables. Now a requirement came up to include current value for the attributes. ( SCD-1). For this we are planning to add new attribute for each and every SCD-2 attribute to the dimension table so that the current job maintains the scd-2 history and have to create another process to update the new attributes with current value ( CURR_IND='Y) on business keys.
Can i achieve this with in the same job instead of creating post process step for each dimension?Please throw some inputs on better way of desigining.
Thanks in Advance
We have designed SCD-2 model maintaing the history in dimension tables. Now a requirement came up to include current value for the attributes. ( SCD-1). For this we are planning to add new attribute for each and every SCD-2 attribute to the dimension table so that the current job maintains the scd-2 history and have to create another process to update the new attributes with current value ( CURR_IND='Y) on business keys.
Can i achieve this with in the same job instead of creating post process step for each dimension?Please throw some inputs on better way of desigining.
Thanks in Advance