Pinterest • The world’s catalogue of ideas

Explore Scd Type, Type 3 and more!

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 about…

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

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. It resulted in the large increase in the size of tables . To overcome these issue , Slowly Changing Dimension Type-3 which keep history of some attribute in the same record itself .For…

In the last article , we discussed about the Lookup Transformation in Informatica . There we talked about the Cache and UnCache Lookup Transformation. To boost the performance of Lookup Transformation , we mention to cache the lookup data , so it can directly look into cache file instead of connecting to source and then…