Informatica Developer track

Informatica Developer Track or Powercenter Web Based Online Training Curriculum

Introduction and Getting started with Powercenter

• Data Warehousing Concepts
• Data Warehouse
• Data Mart
• OLAP VS OLTP
• Data Warehouse Architecture (Basic)
• Data Warehouse Architecture (with a Staging Area)
• Dimensional Modeling
• Star Schema
• Snowflake Schema
• Dimension
• Fact
• Slowly Changing Dimension (Type 1, 2 and 3)
• Hierarchy
• Confirmed Dimension
• Fact less Fact Table
• Summary / Aggregations table
• Change Data capture

PowerCenter Components

• Designer
• Repository Manager
• Workflow Manager
• Workflow Monitor

Informatica Concepts and Overview

• Informatica Architecture
• 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
• Procedural 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

PowerCenter Transformation Language

• Numeric functions
• String Functions
• Date Functions
• Conversion Functions
• Cleansing Functions
• Aggregate Functions
• User Defined Functions

Advanced Informatica Concepts

• Unconnected lookup Transformation
• Unconnected Stored Procedure to Create and Drop Index
• Mapplets and Types of Mapplets
• Defining Reusable Transformations
• User Defined Functions
• Tasks and Types of Tasks
• Work let and Types of Worklets
• Scheduling Work flow
• Constraint Based Load Ordering
• Target Load Plan
• Types of Batch Processing
• Link conditions
• Mapping Parameters
• Mapping Variables
• Defining Session Parameters
• Session Recovery
• Difference between Normal and Bulk Loading
• Push Down Optimization
• PMCMD Utility
• PMREP Utility
• Incremental Aggregation

Types of Look up Caches

• Static Look up Cache
• Dynamic Look up Cache
• Persistence lookup Cache
• Shared Look up Cache
• Sorter and Rank Cache

Task Types

• Session
• Command
• E-mail
• Timer
• Event Wait
• Event Raise
• Decision
• Assignment
• Control
• Work let

Introduction about Informatica Developer tool (Basic Knowledge)

• Understanding Data Objects
• Profiling on Source data
• Parsing Data
• Standardizing Data
• Validating Address data

Delivery Methodology

• We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course

Class Delivery

• Live Interactive classes with expert