Tutorial corner

Informatica,ETL,oracle,sql/plsql

slow changing dimension

slowly changing dimension type 6 with example | SCD6

SCD Type 6

slowly changing dimension type 6 : As we saw in last tutorial , Slowly Changing Dimension Type 2, tracks historical changes by  keeping multiple records for a given natural key in the dimensional tables. Slowly Changing Dimension Type 3 which keep history of some attribute in the same record itself .Slowly Changing Dimension is combination of SCD 1 + SCD […]

SCD type 3 in informatica mapping with example

SCD Type 3

In last tutorial , we talked about  Slowly Changing  Dimension Type 3  in Dataware house . We have gone through the several examples of SCD Type 3 their advantages and disadvantages as well. In below tutorial ,we will implement SCD Type 3 (Slowly Changing Dimension Type 2) in Informatica mapping. In below example we will talk […]

slowly changing dimension type 2 with example | SCD2

SCD Type 2

Concept of slowly changing dimension type 2 : Contrary to  Slowly Changing Dimension Type-1 ,  Slowly Changing  Dimension Type 2  (also known as SCD Type 2), also tracks historical changes  by  keeping multiple records for a given natural key in the dimensional tables .For example , we may need to track the current location of a supplier along […]

Copyright 2015 - Tutorial Corner Frontier Theme