Hi,

My query is on SCD type 2 transformation (using 'effective from' and 'expiration date')

I need to customize this in such a way that the succeeding changes for a particular record should have the

'Effective from' date = previous 'expiration date' +1 day.

Using the SCD wizard, I'm getting the same date for both 'expiration date' (of the outdated record) and 'effective from' date (of the updated record).

please advice me ..

t

Hi Raja,

SCD Task works post-factum per-se so it grabs and processes what the data has.

Some other process based on some criterion would need to set the ''Effective from' date = previous 'expiration date' +1 day' and then you let the SCD process that.