LearnDataModeling.Com

Learn Testing! - Software Testing Life Cycle and Mobile Apps Testing.

Learn BI & Informatica! Fundamentals and concepts with real-time examples.

 
  • Home
  • Business Process
  • Data Modeling(DM)
  • DM & Database
  • DW & ETL
  • Software & Mobile Apps Testing
  • BI
  • Cloud Computing




You are here: Home Data Warehouse & ETL Informatica - Transformations

Informatica - Transformations

[Submitted by:Radhika, Michigan, US.]

In Informatica, Transformations help to transform the source data according to the requirements of target system and it ensures the quality of the data being loaded into target.

Transformations are of two types: Active and Passive.

Active Transformation

An active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.

Passive Transformation

A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.


         


Transformations can be Connected or UnConnected.

Connected Transformation

Connected transformation is connected to other transformations or directly to target table in the mapping.

UnConnected Transformation

An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.

Following are the list of Transformations available in Informatica:

  • Aggregator Transformation
  • Expression Transformation
  • Filter Transformation
  • Joiner Transformation
  • Lookup Transformation
  • Normalizer Transformation
  • Rank Transformation
  • Router Transformation
  • Sequence Generator Transformation
  • Stored Procedure Transformation
  • Sorter Transformation
  • Update Strategy Transformation
  • XML Source Qualifier Transformation
  • Advanced External Procedure Transformation
  • External Transformation

In the following pages, we will explain all the above Informatica Transformations and their significances in the ETL process in detail.



Page 1   2   3  4  5





Quick Links
» Business/Data Modeling Types
» Business Process Modeling
» Data Modeling Overview
» Steps to create a Data Model
» Supertype & Subtype
» Erwin Tutorial
» Dimensions
» Slowly Changing Dimensions
» Star Schema
» Data Warehouse Concepts
» ETL Concepts
» What is Business Intelligence?
Home     |     About Us     |     Contact Us     |     Testimonial     |     Articles     

Copyright© 2012 Pro Business Systems LLC. All Rights Reserved. Contact: Admin_ldm@ProBiZsys.Com.

 Online Users