About Course

Informatica Powercenter course will help you to understand the use of Informatica Powercenter tool in an ETL and Data Integration Process. This course will help you understand the architecture, User interface and   working with Designer, Workflow Manager, Repository Manager and Monitor Informatica Powercenter tools. The attendees will understand the use of various transformations, properties, templates and techniques available in the tool to extract, transform and load the data in real time project scenario. The course will cover the execution, monitoring, debugging and troubleshooting the ETL workflows using the session and workflow logs.  The course will also help you understand the interpretation of the business requirements into the technical requitrments.

Trainer's Information

Trainers are having more than 10+ years of experience using Informatica Powercenter tool. They have worked in various organizations and in diverse domains at different levels. Our trainers are well versed with the Banking, Telecom, Retail, Health Care, Pharma, Airline Domains. They have worked on complex business requirements, successfully interpreted the requirements and build the Enterprise datawarehouse for various clients which helped clients to better analyze their business and take better decisions. Our  trainers has been highly appreciated by the clients for diversified and vast knowledge and experience  in the Informatica Powercenter tool and data warehousing concepts.

Any Pre-requisite:

  • Basic knowledge of SQL.
  • Basic knowledge of Unix.

After completion of this course you will be able to :

  • Work as Informatica Powercenter professional.
  • Develop jobs/mappings using power-center.
  • Handle Business requirements using various transformations of tool.
  • You will be able to create informatica mappings which handle various business requirements and execution of jobs.
  • You will implement many real time scenarios as Lab exercises from this course and that you can implement in your jobs.
  • Work as a individual or in a team of DWH projects.
  • Work on Informatica Powercenter administration and installation.

Power Center Architecture and Components

  • Introduction to informatica Power Center
  • PowerCenter 9.x architecture
  • Extraction, Transformation and loading process
  • Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager.
  • Repository Server and agent
  • Security, Repository, privileges and folder permissions

Power Center Developer Topics:

Lab 1- Create a Folder.

Source Object Definitions

  • Source types
  • 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 5 - Start and Monitor a Workflow.

Debugger

  • Debugger features
  • Debugger windows
  • Tips for using the Debugger

Lab 6 - 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 7- 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 8 - 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 9 - 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.

Lab 10 -Basic Lookup

Lookup transformation

  • Lookup principles
  • Lookup properties
  • Lookup techniques
  • Connected and unconnected lookups.

Lab 10 -Basic Lookup

Update Strategy transformation

  • Update strategy expressions

Lab 11 - Data Driven Inserts and Rejects

Update Strategy transformation

  • Update strategy expressions

Lab 11 - Data Driven Inserts and Rejects

Router transformation

  • Using a router
  • Router groups

Lab 12 - Router

Conditional Lookups

  • Usage and techniques
  • Advantage
  • Functionality

Lab 13 - Straight Load

Lab 14 - Conditional Lookups

Heterogeneous Targets

  • Heterogeneous target types
  • Target type conversions and limitations

Lab 15 - Heterogeneous Targets

Mapplets

  • Functionality and Advantages

Lab 16 - Mapplets

Reusable transformations

  • Advantages
  • Limitations
  • Promoting and copying transformations

Lab 17 - Reusable transformations

Sequence Generator transformation

  • Using a sequence Generator
  • Sequence Generator properties

Dynamic Lookup

  • Dynamic lookup theory
  • Usage and functionality
  • Advantages

Lab 18 - Dynamic Lookup

Concurrent and sequential Workflows

  • Concurrent Workflows
  • Sequential Workflows
  • Stopping, Starting and suspending tasks and workflows

Lab 19 - Sequential Workflow

Other Basics Transformations

  • Union Transformation
  • Rank transformation

Lab Sessions - For above transformations

Error Handling

  • Overview of Error Handling Topics

Lab 20 - Error handling fatal and non Fatal

Workflow Tasks:

  • Command
  • Email

Lab Sessions - With Workflow tasks

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 21 - Override Mapping Variable with Parameter Files

Slowly Changing Dimensions Type 1, Type 2

Lab 22- SCD 1, 2


Leave your feedback