Informatica

 

Informatica’s product portfolio focused on Data Integration: Application Information Lifecycle Management, B2B Data Exchange.

Pre-requisites

The pre-requisites for this course include knowledge of SQL and basic UNIX.

COURSE CONTENT

 

Informatica Concepts and Overview

    • Data Warehousing concepts
    • ETL Concepts.
    • Informatica Architecture.

Power Center Tools

    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor

Basic Concepts and Components

    • Source Qualifier
    • Target Designer
    • Transformations
    • Mappings
    • Mapplets
    • Sessions
    • Tasks

Sources

    • Working with relational Sources
    • Working with Flat Files

Targets

    • Working with Relational Targets
    • Working with Flat file Targets

Transformations

    • Expression Transformation
    • Lookup Transformation
    • Sequence Generator Transformation
    • Filter Transformation
    • Joiner Transformation
    • Sorter Transformation
    • Router Transformation
    • Aggregator Transformation
    • Update Strategy Transformation
    • Union Transformation
    • Rank Transformation
    • Transaction Control Transformation
    • Normalizer Transformation
    • Source Qualifier Transformation
    • Stored Procedure Transformation
    • XML Source Qualifier Transformation
    • Debugging Mappings

Advanced Informatica Concepts

    • Unconnected lookup Transformation
    • Mapping Parameters
    • Mapping Variables
    • Target Load Plan
    • Defining Reusable Transformations.
    • Mapplets
    • Tasks And Types of Tasks.
    • Worklet
    • Scheduling Workflow
    • Types of Batch Processing
    • Link conditions
    • Defining Session Parameters
    • PMCMD Utility

Types Of Lookup Caches

    • Static LookUp Cache
    • Dynamic LookUp Cache
    • Perisistance lookup Cache
    • Shared LookUp Cache

Task Types:

    • Session
    • Command
    • Worklet
    • EMAIL
    • Timer
    • Event Wait
    • Event Raise
    • Decision
    • Control