Comprehensive Introduction To Informatica

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

Contact us for details.

Prerequisites

Contact us for details.

Course Outline:

Introduction to Data Warehousing Concepts.

• What is Data warehousing?
• Who needs Data warehouse?
• OLTP Vs OLAP
• Why Data warehouse is required?
• Components of a Data warehouse & Architecture
• Data Cleansing   ? ODS (Operational Data Store)
• Understand Dimensions, Fact tables
• What is Confirmed Dimension, Factless Fact Table
• Understand Datwarehouse Schema- Star Schema, Snowflake Schema

Introduction to ETL

• Components of ETL
• Various ETL tools available in Market

Power Center Architecture and Components:

• Introduction to Informatica Power Center (Data Integration)
• Components of Power Center:
  • Power Center Server Components:
    • Integration Server
    • Repository Server
  • Power Center Client tools:
    • Repository Manager
    • Designer
    •   Workflow manager
    •   Workflow Monitor

Informatica Power Center Designer

• Introduction to designer
• Designer Interfaces
• Designer tools
• Connecting to Designer
• Components of Designer
• Creating Data Source Names (ODBCs)
• Accessing the source, destinations to the designer
• Defining Sources using Source Analyzer
• Database as a source
• Flat Files sources
• Defining Targets using Target Designer
• Working with Relational Targets
• Working with Flat File Targets
• Creating target database objects
• Mapping designer
• Mapping between the source and target tables
• Transformation between source and target tables

Informatica PowerCenter Designer Understand Transformations

• What are Informatica Transformations
  • Active and Passive Transformations
  • Connected and Unconnected Transformations

Informatica Transformations:

• Filter Transformation
• Router Transformation
• Expression Transformation
• Source Qualifier Transformation
• Joiner Transformation
• Sorter Transformation
• Aggregator Transformation
• Rank Transformation
• Union Transformation
• Lookup Transformation:
  • Connected and Unconnected Lookup
• Lookup Caches: 
  • Static
  • Dynamic
  • Persistent
  • ReCache
• Sequence Generator Transformation
• Update Strategy Transformation

Informatica PowerCenter Reusable Components

• Creating Reusable Transformations using Transformation Developer
• Creating Mapplets using Mapplet Designer
• Creating Worklets using Worklet Designer

Informatica PowerCenter Workflow Manager

• Define Informatica Workflow and why do we need them
• How to create a Workflow using Workflow Manager
• Components of a Workflow
• Defining Tasks in Workflow
• Create a Command Task
• Configure Event Wait
• Create a Email Task
• Create a Session Task and understand different settings
• Start Workflow
• Monitor Workflow
• Understand Session logs
• Understand Workflow Logs

 
Slowly Changing Dimensions (SCDs):

• SCD concept (Slowly Changing Dimensions)
  • Understand the Flow of Type-I mappings
  • Understand the Flow of Type-II mappings
  • Understand Type-III mappings