Type 3 Slowly Changing Dimension | Informatica The Type 3 Keeps Limited History . The Number of Columns Created For Storing Historical Records. The Source Table Structure in Type 1 and Type 2 Are Same But Type 3 Includes Additional Columns. Lookup,Expression,Router and Sequence Generator Transformation Need To Use Of.