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

About Me

Latest Updates
View my complete profile
Powered by Blogger.