implementation of SCD Type 2 with timestamp

harish841913 · Post by **harish841913** » Mon Jun 06, 2011 5:11 am

hi i want to implement scd type 2 with timestamp in my project i have 3 modules like claims,capitation,duncan and i have to load it into Sybase ODS.

I NEEDonly to append the data into ods so can i use 3 scd jobs or i have to use scd jobs dependent on each table.

chulett · Post by **chulett** » Mon Jun 06, 2011 7:02 am

Are you asking if you can build generic jobs per module using something like the SCD stage, schema files and/or RCP rather than specific jobs per table? What does "I need only to append the data into ods" mean? To me that doesn't sound very type-2-like.

harish841913 · Post by **harish841913** » Mon Jun 06, 2011 7:49 am

chulett wrote:Are you asking if you can build generic jobs per module using something like the SCD stage, schema files and/or RCP rather than specific jobs per table? What does "I need only to append the data into ods" mean? To me that doesn't sound very type-2-like.

Yes chulett

chulett · Post by **chulett** » Mon Jun 06, 2011 9:01 am

How about an answer for the second question.

harish841913 · Post by **harish841913** » Mon Jun 06, 2011 12:11 pm

chulett wrote:How about an answer for the second question.

i want to create generic jobs for each module and maintain history how can i achive this