Informatica Power center Tutorial

Installation of Informatica

• Informatica power center 8.6 Installation

Informatica Power Center

• What is Informatica ?                    
• ODBC Connection in Informatica
• Informatica Power Center

                                             Sources

                                             Targets

                                             Power Center repository

                                             Repository Server

                                             PowerCenter Client

                                             Power Center Server

                                             Database Connections

                                             Powercenter Metadata Reporter

• Using the Repository Server Administration Console
• Repository Objects
• The Power center Design Process
• Power Center Client
• Workflow Manager
• Workflow Monitor
• Power center Admin Console
• Getting started  with Informatica
• Changing Data Movement Modes
• Code Page Overview
• Power Center Server Variable Directories 

Informatica Transformations

• Expression Transformation
• Filter Transformation
• Router Transformation
• Sorter Transformation
• Rank Transformation
• Source Qualifier Transformation
• Aggrigator Transformation
• Joiner Transformation
• Sequence Generator Transformation
• SQL Transformation
• Stored Procedure Transformation
• Transaction Control Transformation
• Lookup Transformation
• Union Transformation
• Normalizer Transformation
• Update Strategy Transformation
• Java Transformation
• HTTP Transformation
• Transformations in Informatica 9 ....Latest
• Define the Properties available in Sequence Generator transformation in brief.

Informatica Topics: -

• Incremental Loading for Dimension Tables
• Target Load Order
• Mapping Debugger
• Constraint based Load Order
• Change Data Capture (CDC)
• Informatica Functions
• Setup Environment variables for PMCMD/PMREP 
• pmcmd Commands
• New pmrep Commands
• Informatica Server Process
• MAPPING PARAMETERS
• MAPPLETS
• WORKING WITH LINKS
• INFORMATICA SCHEDULERS

·         Identify the bottlenecks in Informatica?

·         Changing Data Movement Modes

·         CODE PAGE OVERVIEW

·         Informatica Reject File - How to Identify rejection reason

·         Identify the bottlenecks in Informatica?

·         Working with Post-Session Email

·         Output Files in Informatica

·         Power Center Server Variable Directories

TASKS in Informatica

• SESSION TASK 
• EMAIL TASK 
• COMMAND TASK 
• WORKING WITH EVENT TASKS 
• TIMER TASK 
• DECISION TASK 
• CONTROL TASK 
• ASSIGNMENT TASK 

Slowly Changing dimensions

• SCD Type-1 Implementation in Informatica using dynamic Lookup

• SCD TYPE1 MAPPING

• Informatica Scd Type-2 implementation

Informatica Performance Tuning

• Performance tuning Overview
• Identification of Bottlenecks
• Optimizing the Bottlenecks
• Performance Tuning of Look-up
• Informatica Tuning - Step by Step Approach
• Look-up Transformation Performance Optimization

Informatica Interview Questions & Answers

• Informatica Real-time Interview Quiestions
• Informatica Experienced questions
• Informatica Experienced Quiestions
• Informatica Real-time Scenarios
• Informatica Real-time Scenarios

Diff between Informatica 7.1 and 8.6

• Diff between Informatica 7.1 and 8.6

Informatica Testing

• Unit Testing
• Integration Testing
• User acceptance Testing
• Testing in informatica

ETL Life Cycle

• ETL Life cycle

Informatica Real-time Project

• Informatica Real-time Project [ETL]
• ETL (Extract-Transform-Load) for Data Warehousing

Informatica Interview Questions on Transformations.

• Informatica Interview Questions on Expression Transformation

• Informatica Interview Questions on Filter Transformation

• Informatica Interview Questions on Aggregator Transformation

• Informatica Interview Questions on Joiner Transformation

• Informatica Interview Questions on Normalizer Transformation

• Informatica Interview Questions on Rank Transformation

• Informatica Interview Questions on Router Transformation

• Informatica Interview Questions on Sequence Generator Transformation

• Informatica Interview Questions on Source Qualifier Transformation

• Informatica Interview Questions on Stored Procedure Transformation

• Informatica Interview Questions on Update Strategy Transformation

• Informatica Interview Questions on Lookup Transformation

• Informatica Interview Questions on SQL Transformation

• Informatica Interview Questions on Sorter Transformation

• Informatica Interview Questions on Transaction Control Transformation

• Informatica Interview Questions on Union Transformation