Book Image

Implementing Informatica PowerCenter 9 [Video]

By : Rahul Malewar
Book Image

Implementing Informatica PowerCenter 9 [Video]

By: Rahul Malewar

Overview of this book

This video course begins by teaching you all there is to know about transformations, one of the most important aspects in Informatica. These transformations are arranged on the basis of their importance and usage. You will learn how to use transformations such as Aggregator and Filter, after which you will move on to more advanced transformations such as Joiner, Union, and Rank. The second half of this course revolves around how to classify transformations, based on whether they're active/passive, or connected/unconnected. Finally, you will learn to implement the Slowly Changing Dimension problem and sharpen your data warehousing skills!
Table of Contents (4 chapters)
Chapter 4
Implementing SCD
Content Locked
Section 4
Implementing SCD3 Mapping
Our aim is to understand SCD3 mapping - Discuss the logic for the implementation - Look at the wizard used for mapping - Understand the transformations used