Informatica Complete Reference

Informatica Real-time Project [ETL]

What is Informatica ?

Transformations in Informatica 9 ....Latest


Informatica Tuning - Step by Step Approach

Look-up Transformation Performance Optimization

Change Data Capture (CDC)

Diff Between OLTP and OLAP


Informatica Server Process

Power Center Client

ETL Life cycle


Unit Testing

Integration Testing

User acceptance Testing

Debugger

Constraint based Load Order

Target Load Order

Incremental Loading for Dimension Tables

Data Warehousing Schemas

Informatica Real-time Scenarios

Informatica Functions

Informatica Experienced Quiestions

Informatica Experienced questions

Informatica Real-time Interview Quiestions

Informatica power center 8.6 Installation

Diff between Informatica 7.1 and 8.6

Power center Admin Console

Informatica Real-time Scenarios

What is Data Modeling?

Fact Table

Star Schema v/s Snowflake Schema

Setup Environment variables for PMCMD/PMREP

.....................................................................................

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


.....................................................................................


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