Opening book details…
Can I read Implementing SCD Type 2 in Informatica on EtoBox?
Implementing SCD Type 2 in Informatica by Svr Ravi is a document available to read on EtoBox.
What is Implementing SCD Type 2 in Informatica about?
This document provides instructions on how to implement a slowly changing dimension (SCD) Type 2 mapping with flagging in Informatica. It describes the key steps to identify new, changed, and unchanged records and insert/update them in the target dimension table along with a flag column. The steps are divided into 4 parts that cover setting up the source and target, identifying new/changed records, inserting new/changed records with flag=1, and updating unchanged records with flag=0.
- Author
- Svr Ravi
- Language
- EN