Informatica Training

Informatica Online Training

Data Warehousing Concepts

  •  Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)
    •    Slowly Changing Dimensions (SCD1, SCD2, SCD3)
    •    Metadata
    •    Dimentinal Table
    •    Types Of Dim Tables
    •    Fact Table
    •    Types of Fact Tables
    •    OLTP (OnLine Transaction Processing)
    •    OLAP (Online Analysis And Processing)
    •    OLTP Vs OLAP
    •    Advantages of OLAP
    •    Different Methodologies of DWH
    PowerCenter Components and User Interface
  • InformaticaPowerCenter Architecture
    •    InformaticaPowerCenter Client Tools
    •    Start Using of the Designer, Workflow Manager and Workflow Monitor

Source Qualifier

  •  Source Qualifier Transformation
    •    SQL override in source qualifier transformation
    •    Source qualifier transformation joins concept
    •    Source qualifier transformation on Relational Databases
    •    Source qualifier transformation on File systems
    •    Source qualifier transformation filter concepts
    •    Difference Between SQL Override, Other Options
    •    Source Qualifier Transformation Performance Tunning
    •    Pre SQL and Post in Source Qualifier Transformation

 Expression, Filter, File Lists and Workflow Scheduler

  •  Expression Editor
    •    Filter Transformation
    •    File Lists
    •    Workflow Scheduler
    •    Lab – Load the Customer Staging Table and Real time issues

Joins, Features and Techniques I

  •  Joiner Transformation
    •    Shortcuts
    •    Lab A – Load Sales Transaction Staging Table
    •    Lab B – Features and Techniques I and Real time issues

Lookups and Reusable Transformations

  •  Lookup Transformation
    •    Reusable Transformations
    •    Lab A – Load Employee Staging Table
    •    Lab B – Load Date Staging Table and Real time issues

Debugger

  •  Debugging Mappings
    •    Lab – Using the Debugger

Sequence Generator

  •  Sequence Generator Transformation
    •    Lab – Load Date Dimension Table and Real time issues

Lookup Caching, More Features and Techniques

  •  Lookup Caching
    •    Lab A – Load Promotions Dimension Table
    •    Lab B – Features and Techniques II
    •    Review and more Lab Activities and Real time issues

Router, update Strategy and Overrides

  •  Router Transformation
    •    Update Strategy Transformation
    •    Expression Default Values
    •    Source Qualifier Override
    •    Target Override
    •    Session Task Mapping Overrides
    •    Lab – Load Employee Dimension Table and Real time issues

Dynamic Lookup and Error Logging

  •  Dynamic Lookup
    •    Error Logging
    •    Lab – Load Customer Dimension Table

Unconnected Lookup, Parameters and Variables

  •  Unconnected Lookup Transformation
    •    System Variables
    •    Mapping Parameters and Variables
    •    Lab – Load Sales Fact Table

Sorter, Aggregator and Self-Join

  •  Sorter Transformation
    •    Aggregator Transformation
    •    Active and Passive Transformations
    •    Data Concatenation
    •    Self-Join
    •    Lab – Reload the Employee Staging Table and Real time issues

SCD type1 – Hands-On LAB

SCD type2 – Hands-On LAB

SCD type3 – Hands-On LAB

Mapplets

  •  Mapplets
    •    Lab – Load Product Daily Aggregate Table
    •    Review and more Lab Activities and Real time issues

Workflow Variables and Tasks

  •  Link Conditions
    •    Workflow Variables
    •    Assignment Task
    •    Decision Task
    •    Email Task
    •    Lab – Load Product Weekly Aggregate Table

More Tasks and Re-usability

  •  Event Raise Task
    •    Event Wait Task
    •    Command Task
    •    Reusable Tasks
    •    Reusable Session Task
    •    Reusable Session Configuration

Worklets and More Tasks

  • Worklets
    •    Timer Task
    •    Control Task