Tell a Friend

Informatica

      Informatica Course

 

Informatica Power Center 9

Timings:

Mornings/Evenings/Weekends/Custom

Mode of Training:

 Regular/Fast Track  

Course Duration:

30 hrs (Class: 1 hr/weekdays)

Software:

Informatica 9 Server/Client

What we Offer:

* Quality Training            * Flexible Timings

* 24/7 Server Access      * Hands-On Training

 

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

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

Administration 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 Privileges
  • Source Object Definitions
    • Source type
      • Relational Tables (Oracle, Teradata)
      • Flat Files (fixe width, Delimiter Files)
      • Xml Files
      • Cobol Files
      • SalesForce
    • 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

Labs 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
    • 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 Transformation
    • Stored Procedure Transformation
    • External procedure Transformation
    • SQL Transformation

Lab 22 – For above transformations

  • Error Handling
    • Overview of Error Handling Topics

Lab 23 – Error handling fatal and non Fatal

  • Workflow Tasks
    • Command
    • Email
  • Decision
  • Timer
  • Control
  • Even Raise and Wait
  • Sequential Batch Processing
  • Parallel Batch Processing

Lab 24 – Working 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.

Lab 25 – Mapping Parameters and Variables

  • Introduction to Mapping 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.

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

Lab 30 – PMCMD

  • PMREP
  • Informatica Migrations:
    • Copying Objects
    • Objects export and import (XML)
    • Deployment groups
  • Workflows Scheduling:
    • Using Informatica
    • Unix crontab, third party tools.

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
 

 


 

Additional information