This is a practical step by step hand-on guide to learn and master Informatica.

Informatica is widely used ETL tool and provided end to end data integration and management solution. This book introduces Informatica in detail. It provides a detailed step by step installation tutorial of Informatica. It teaches various activities like data cleansing, data profiling, transforming and scheduling the workflows from source to target in simple steps, etc.

Here is what you will learn –

Chapter 1: Introduction to Informatica

Chapter 2: Informatica Architecture Tutorial

Chapter 3: How to Download & Install Informatica PowerCenter

Chapter 4: How to Configure Client and Repository in Informatica

Chapter 5: Source Analyzer and Target Designer in Informatica

Chapter 6: Mappings in Informatica: Create, Components, Parameter, Variable

Chapter 7: Workflow in Informatica: Create, Task, Parameter, Reusable, Manager

Chapter 8: Workflow Monitor in Informatica: Task & Gantt Chart View Examples

Chapter 9: Debugger in Informatica: Session, Breakpoint, Verbose Data & Mapping

Chapter 10: Session Properties in Informatica

Chapter 11: Introduction to Transformations in Informatica and Filter Transformation

Chapter 12: Source Qualifier Transformation in Informatica with EXAMPLE

Chapter 13: Aggregator Transformation in Informatica with Example

Chapter 14: Router Transformation in Informatica with EXAMPLE

Chapter 15: Joiner Transformation in Informatica with EXAMPLE

Chapter 16: Rank Transformation in Informatica with EXAMPLE

Chapter 17: Sequence Transformation in Informatica with EXAMPLE

Chapter 18: Transaction Control Transformation in Informatica with EXAMPLE

Chapter 19: Lookup Transformation in Informatica & Re-usable Transformation Example

Chapter 20: Normalizer Transformation in Informatica with EXAMPLE

Chapter 21: Performance Tuning in Informatica