Informatica Online Training

Home / Informatica Online Training

INFORMATICA ONLINE TRAINING COURSE

Duration: 4 –  5 Weeks

Data Warehouse Concepts:
  • Introduction to Data warehouse
  • What is Data warehouse and why we need Data warehouse
  • OLTP vs ODS vs Data warehouse
  • Dimensional modeling
  • Star schema/Snowflake schema/Galaxy schema
  • Dimensions / Facts tables.
  • Slowly Changing Dimensions and its types.
  • Data Staging Area
  • Different types of Dimensions and Facts.
  • Data Mart vs Data warehouse
  • DWH Approaches: Ralph Kimball’s vs Bill Inmon’s
Informatica Power Center 9:
Software Installation:

Informatica 9 Server/Client Installation on Windows/Unix.

Power Center Architecture and Components:
  • Introduction to Informatica Power Center
  • Difference Between Power Center and Power Mart
  • PowerCenter 9 architecture
  • PowerCenter 7 architecture vs PowerCenter 8 and 9 architecture
  • Extraction, Transformation and loading process 
Power Center tools:

Designer, Workflow manager, Workflow Monitor,

Repository Manager, Informatica Adminstration Console.
  • Repository Server and agent
  • Repository maintenance
  • Repository Server Administration Console
  • Security, Repository, privileges and folder permissions
  • Metadata extensions
Power Center Developer Topics:
Lab 1- Create a Folder.
  • How to provide Previllages
  • Source Object Definitions
        Source types

–       Relational Tables (Oracle, Teradata)
–       Flat Files (fixe width, Delimiter Files)
–       Xml Files
–       COBOL Files
–       Sales Force

Source properties
Lab 2- Analyze Source Data, Import Source.
  • Target Object Definitions

–       Target types
–       Target properties

Lab 3- Import Targets
  • Transformation Concepts
  • Transformation types and views
  • Transformation features and ports
  • Informatica functions and data types

Mappings

  • Mapping components
  • Source Qualifier transformation
  • Pre SQL and Post SQL
  • Mapping validation
  • Data flow rules
Lab 4 –Create a Mapping, session, and workflow
Workflows
  • Workflow Tools
  • Workflow Structure and configuration
  • Workflow Tasks
  • Workflow Design and properties
Session Tasks
  • Session Task properties
  • Session components
  • Transformation overrides
  • Session partitions
Workflow Monitoring
  • Workflow Monitor views
  • Monitoring a Server
  • Actions initiated from the workflow Monitor
  • Gantt chart View and Task view.
Lab 6 – Start and Monitor a Workflow
Debugger
  • Debugger features
  • Debugger windows
  • Tips for using the Debugger
Lab 7 –The Debugger
Expression transformation
  • Expression, variable ports, storing previous record values.
Different type of Ports
  • Input/ output / Variable ports and Port Evaluation
  • Filter transformation
  • Filter properties
Lab 8- Expression and Filter
Aggregator transformation
  • Aggregation function and expressions
  • Aggregator properties
  • Using sorted data
  • Incremental Aggregation
Joiner transformation
  • Joiner types
  • Joiner conditions and properties
  • Joiner usage and Nested joins
Lab 9 – Aggregator, Heterogeneous join
  • Working with Flat files
  • Importing and editing flat file sources & Targets

Lab Session – Use Flat file as source.

Sorter transformation
  • Sorter properties
  • Sorter limitations
Lab 10 – Sorter
  • Propagate Attributes.
  • Shared Folder and Working with shortcuts.
  • Informatica built in functions.
Lookup transformation
  • Lookup principles
  • Lookup properties
  • Lookup techniques
  • Connected and unconnected lookups.
  • Lookup Caches
Lab 11 – Basic and Advance Lookup
 Target options
  • Row type indicators
  • Row loading operations
  • Constraint- based loading
  • Rejected row handling options
Lab 12 – Deleting Rows
  • Update Strategy transformation
  • Update strategy expressions
Lab 13 – Data Driven Inserts and Rejects
  • Router transformation

Using a router

Router groups

Lab 14 – Router
  • Conditional Lookups

Usage and techniques

Advantage

Functionality

Lab 15 – Straight Load
Lab 16 – Conditional Lookups

 

Heterogeneous Targets
  • Heterogeneous target types
  • Target type conversions and limitations

Lab 17 – Heterogeneous Targets

Mapplets
  • Functionality and Advantages
  • Mapplet types and structure
  • Mapplet limitations
Lab 18 – Mapplets
  • Reusable transformations
  • Advantages
  • Limitations
  • Promoting and copying transformations
Lab 19 – Reusable transformations
  • Sequence Generator transformation
  • Using a sequence Generator
Sequence Generator properties
  • Dynamic Lookup
  • Dynamic lookup theory
  • Usage and functionality
  • Advantages
Lab 20 – Dynamic Lookup
  • Concurrent and sequential Workflows
    • Concurrent Workflows
    • Sequential Workflows
  • Stopping, Starting and suspending tasks and workflows
Lab 21 – Sequential Workflow
  • Additional Transformations
    • Union Transformation
    • Rank transformation
    • Normalizer transformation
    • Custom Transformation
    • Transformation Control transformation
    • XML Transformation
    • SQL Trasnformation
    • Stored Procedure Transformation
    • External procedure Transformation
    • SQL Transformation
  • Lab Sessions- For above transformations
  • Error Handling
  • Overview of Error Handling Topics
Lab 22 – Error handling fatal and non Fatal
  • Workflow Tasks:
    • Command
    • Email
    • Decision
    • Timer
    • Control
    • Even Raise and Wait
    • Sequential Batch Processing
Parllel Batch Processing
  • Lab Sessions – With Workflow tasks
  • Link Conditions
  • Team Based Development
Version Control
Checking out and checking in objects.
  • Performance Tuning
  • Overview of System Environment
  • Identifying Bottlenecks.
Optimizing Source, Target, mapping, Transformation, session.
  • Mapping Parameters and Variables
Introduction to Mappng Variables and Parameters
  • Creating Mapping Variables and Updating Variables
  • Creating Parameter File and associating file to a Session
  • System Variables
  • Variables functions
Lab 26 – Override Mapping Variable with Parameter Files
Lab 27 – Dynamically Updating a Source Qualifier with Mapping Variable
  • Slowly Changing Dimensions Type 1, Type 2, Type 3
  • Incremental Loading
Lab 28– SCD 1, 2, 3
  • Reusable Workflow Tasks
  • WorkLets
  • Worklets Limitation
  • Sessions
  • Reusable Sessions
Lab 29 – Create Worklets using Tasks
  • Command Line Interface ( PMCMD)
  • Overview of PMCMD and functions.
  • Overview of PMREP and functions.
Lab 30 : PMCMD
  • PMREP
  • Informatica Migrations:
Copying Objects
  • Objects export and import (XML)
  • Deployment groups
  • Workflows Scheduling:
  • Using Informatica
  • Unix crontab, third party tools.
Lab 30: Informatica Project- Case Study
  • Sales Data mart.
  • Loading Dimensions and Facts.
  • ETL Best Practices and methodologies
  • Review the Industry best practices in ETL Development
  • Review Real time project experiences of trainer
  • Discuss what is learned techniques are useful in real world
  • How to design effective ETL process
  • Important considerations in designing ETL process
  • Discuss real world production issues and support
  • Discuss various roles in ETL world
  • Business Analyst, System Analyst
  • System Architect
  • Technical Architect, ETL Lead
  • Stakeholders, Business users
  • Effective ways of using Data warehouse
  • Review various BI Reporting methods
    • Q/A-Interview preparation/Placements
    • Answer students questions
    • Tips for interview preparation
    • How we can assist in placement and future growth
    • Discuss other related technologies like Business Intelligence (BI)
    • Advancing career options