Spindustry News

Azure For IT Professionals

Learn more about implementing Azure as part of your infrastructure.

Staying Sharp on Microsoft Office Can Save Time & Money

Learning the latest Microsoft Office tips and tricks can benefit you greatly.

"How do I determine if this new technology is for real?"

Michael Bird explains how to navigate new technology waters.
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Comprehensive Introduction To Informatica

Course Code: INFMA0001
Length: 5 Days
Tuition: $3,245.00

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

 

back to top