Basic Informatica Tutorial
Showing posts with label
Slowly Changing Dimensions
.
Show all posts
Showing posts with label
Slowly Changing Dimensions
.
Show all posts
Saturday, June 29, 2019
SCD Type 2 Flag
›
SCD Type 2 Flag is the method used to store historical data is maintained along with current data. - Create a mapping and name it. - Dr...
SCD Type 2 Effective Date
›
SCD Type 2 Effective Date is the method used to store historical data is maintained along with current data. - Create a mapping and n...
Sunday, April 14, 2019
SCD Type 2 Version
›
In this SCD Type 2 historical data is maintained along with current data. SCD Type 2 concept can be implemented with 3 different methods. D...
Saturday, April 13, 2019
SCD Type 1
›
Previously we use to check the option truncate table but when ever we use to load data into target our previous data used to be deleted and...
Friday, April 12, 2019
Introduction to SCD's
›
Lets consider the example of a company which was started many years ago. At the starting company will store all the information about the e...
›
Home
View web version