Informatica Power Center 8.6 Developer Level-1

Have Queries? Ask us +91 72592 22234

Course Overview


This "Informatica Power Center 8.6" Level 1 Developer course provides the basic skills and knowledge to developers who are new to Informatica Power Center and need to implement data integration projects, exposing core features of Power Center through lectures and hands-on exercises. In addition to gaining tremendous insight into the data integration platform, Participants shall be exposed to "ETL Process", Basic Data Warehousing Concepts, Informatica Best Practices, Performance tuning, and the use of technical support options.

Course Content


Introduction to Informatica Powercenter 8.6
Products of Informatica
Informatica Architecture

  • Overview
  • Connectivity
  • Integration/Repository service process
  • Load Balancer
  • Grids /Nodes /Domain
  • Code Pages and Data Movement modes
  • Introduction to ETL
  • Why Informatica
  • Informatica Client Tools

Introduction to ETL

  • Mapping Designer
    • Overview
    • Connecting mapping objects
    • linking ports
    • propagate attributes
    • working with targets /sources
    • Creating Mappings /mapplets (Reusable Objects)
    • Validating a mapping
  • Workflow Manager
    • Copy repository objects
    • Check in & check out versioned objects
    • Links
    • Creating Workflow/Sessions/Tasks (Reusable Objects)
  • Repository Manager
    • Understanding the Repository,Folders
    • Exporting and importing objects
  • Workflow Monitor
    • Gant /task view Reporting.
    • Session and work flow logs

Transformations

  • Source qualifier
    • Overview
    • Properties
    • default query
    • joining source data
    • adding SQL query
    • user defined join
    • outer join support
    • source filter
    • sorted ports
    • pre and post session SQL commands
  • Update strategy
    • Overview
    • Flagging rows within a mapping
    • Setting update strategy for a session
    • Check list
  • Expression
    • Overview
    • Components
    • Configuring ports
    • input vs. Output vs. Variable
  • Aggregator
    • Overview
    • Components
    • Configuring aggregate caches
    • Aggregate expressions
    • Group by ports
    • Sorted input
    • Aggregator transformation
  • Joiner
    • Overview
    • Transformation properties
    • Condition type
    • Sorted input
  • Router
    • working with groups
    • working with ports
    • Rules for connection
  • Rank
    • Overview
    • Ports available
    • Defining groups
  • Sorter
    • Overview
    • Data sorting
    • Properties
    • Cache
    • work directory
  • Filter
    • Overview
    • Components
    • Condition
    • Tips
  • Sequence generator
    • Overview
    • Uses of sequence generator
    • Properties
    • Ports
    • Reusable sequence generator
  • Union
    • Overview
    • Groups and ports
    • Usage
  • Lookup (connected/unconnected)
    • Overview
    • Source types
    • Connected and Unconnected
    • Components properties
    • Look up query
    • SQL Over riding guidelines
    • Look up caches
    • Unconnected transformations
  • Stored procedure (connected/unconnected)
    • Overview
    • Methods of creating sp in a mapping
    • Configuring connected transformation
    • Configuring un connected transformation
    • Error handling
    • Expression rules
  • Transaction control
    • Overview
    • Tct properties
    • Tct in mappings
    • Built in variables
    • Mapping guidelines & validation
  • Normalizer
    • Overview
    • Components
    • Generated keys
    • Pipeline Normalizer
    • Using Normalizer transformation
  • Some Important Concepts
    • SQL Override   
    • Mapping/ Workflow Variables
    • Mapping/ Workflow Parameters   
    • Working with/ Configuring Parameter File.   
    • Overview to PMCMD/PMREP Commands.   
    • Enhanced features in Informatica Version 9.0.1
  • Overview on Data warehousing Concepts
    • Introduction to Data Warehousing
    • Introduction to OLTP, ETL and OLAP Systems
    • Star Schema
    • Snowflake Schema
    • Types of Fact and Dimension Tables
    • Introduction to Slowly Changing Dimension Type 1/2/3

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234