Case Transformation: Summary:- Case transform simplifies branching logic that helps you transform one input dataset into multiple output datasets, based on conditions stored in the expression table, using just one…

Date Generation Transformation: Summary: Date Generation Transformation is used to produces a series of dates incremented that you specify in a separate column. This transform generates a column which holds…

Summary: Effective Date transformation is a readymade logic that helps to define Time Dependent Dimensions. Time dependent dimensions are the attributes which have a validity that expires. Effective Date transformation…

Hierarchy Flattening Transformation: Summary: Hierarchy Flattening is a readymade logic in the form of transform which is used to load Hierarchies in the table form. Hierarchy flattening transformation used to…

Summary:- History preserving transformation is used to maintain all the history of data or records which are updated, inserted and deleted records without changing the existing records. Mapping tries to…