Transformation logic for SCD Type 2 in Datasphere

[tek_ib]

Hello SAP Datasphere experts,

I am fairly new to SAP Datasphere and trying to find out and implement slowly changing dimension type2 in data sphere for the cost center object with Zemployee as an attribute. So if the employee change his department and belongs to a different cost center then it should keep the history.

I created a source table Sourec_CostCenter and Target table Target ZDIM_CostCenter_SCD2

I have all the required fields such as Cost center employee, from and To date, Flag and Record ID but I dont know where should I write or configure and option for SCD type 2. I was told to do it in the transformation but I cant even find the place or transformation where I can configure a logic for SCD type 2.

Can anyone please help me with the screenshot where to write/configure SCDtype2 settings and where do i find this transformation interface.

Will appreciate your help.

Regards

[Martin_Kuma]

Hey there, may there be a misunderstanding? You are looking for a switch, but there is none. The SCD is just another name for time-dependency. Means you activate in your view date-from or date-to fields with semantic type: business date from / to.

DSP uses the semantic type: business date from / to then in AM via the variable: Reference Date Variable. If you do not use the AM variable, the current date is used by default. 

To load the data, just use the date-to field in the target table as key. When you consume the table, you use the semantic type. 

Hope this heps

Cheers,

Martin 

[tek_ib]

OK I see, that makes sense. Actuall I have already done that using the method you suggested above but I was confused that may be there is any transformation or configuration. Anyways thanks for that. Regards