Discover your community to learn, get support, and discuss on different topics within data management and analytics.
This is your platform to ask questions, post answers and share your experience with other customers and experts from SAP.
Hi Team ,
Could you please help me how to design slow changing dimension (Type 2) in DWC ETL flow using graphical method.
Hi @Gurappa Chemuduru,
you could join the master data from the slowly moving dimension (right table) with the transaction data (left data) via a left outer join. Like that you get all the entries from the slow changing dimension even if they dont have transactions in your observed time frame.
Does this help?
Thank you .
My question is how we achieve or manage slow change dimension (type 2 ) data in sap DWC .
For example : Emp id ,Location , Location changed from one place to other so I need to maintain two locations in the table .
We can achieve this traditional ETL tools ,I would like to how we can achieve this in DWC.
@Gurappa Chemuduru : ok I understand now. You could do this with an open SQL schema and your own ETL tools or you wait for the native data flows in DWC: