Informatica ETL

Contact Us
  • Data Acquisition
    • Data Extraction
    • Data Transformation
    • Data Loading
  • ETL Development Life Cycle
  • Informatica Architecture
  • Informatica Powercenter components & User Interface
  • Different types of Sources & Targets
  • Working with Database, Flat file.
  • Basic Simple Pass mapping
  • Use of Transformations:
    • Source Qualifier T/R
    • Sorter T/R
    • Filter T/R
    • Router T/R
    • Rank T/R
    • Expression T/R
    • Sequence Generator T/R
    • Aggregator T/R
    • Union T/R
    • Joiner T/R
    • Lookup T/R
    • Update Strategy T/R
  • SCD Type 1 & Type 2 implementation
  • Different Types of Tasks
  • Mapping Parameter & Mapping Variables
  • Loading text file in indirect method
  • Working with Mapplet
  • Working with Worklet
  • Workflow Scheduling
  • Batch Processing
  • Session Parameter
  • SQL T/R
  • Mapping Debugger
  • Performance Tuning Guidelines
  1. Working knowledge of SQL,PL/SQL
  2. Data Warehousing Concept
  • History, Advantages, Usage etc.
  • Theoretical & Technical Architecture.  ­­
  • Functions of DWH.
  • Data Marts
    • Data Mart concept
    • Top Down Approach
    • Bottom up Approach
  • Data Modeling Concepts.
  • Dimension modeling & OLTP system.
  • Dimension & Fact
  • Schema generation
  • Star & Snow Flake Schema
  • SCD concepts (Slowly changing dimension)
    • Type-1 SCD
    • Type-2 SCD
    • Type-3 SCD
  • ETL Testing