Informatica Power center

Name: Informatica Power center
Rating: 3.9 (32 reviews)

Created byMahesh P

Last updated 3/2018

English

What you'll learn

Informatica power center and ETL

Course content

1 section • 12 lectures • 39h 32m total length

Introduction3:20:53
Designer Repository Manager Workflow Manager Workflow Monitor3:24:01
Master data integration workflows in Informatica PowerCenter using designer repository manager, workflow manager, and workflow monitor; learn to design sources, targets, mappings, and transformations with DSN setup.
Informatica Architecture. Source Qualifier Target Designer Transformations Mappi3:25:34
Explore Informatica architecture and PowerCenter, including source qualifier, target designer, and mappings. Learn to design data flows from source to target with sessions and transformations.
Working with relational Sources Working with Flat Files Working with Relational3:29:58
Explore how to work with relational sources and flat files in Informatica PowerCenter. Build practical mappings using filters, unions, and expression transformations to route data to relational targets.
Expression Transformation Lookup Transformation Sequence Generator Transformatio3:26:51
Explore expression transformations, lookup transformations, and sequence generator transformation in Informatica PowerCenter, with hands-on guidance on staging data, file-to-table loads, and join versus union techniques.
Procedural Transformation Router Transformation Aggregator Transformation Update3:36:20
Explore Informatica PowerCenter transformations, including join, router, and aggregator. Learn to configure left and inner joins, group-by aggregations, ranking, and caching for efficient data integration.
Update Strategy Transformation Union Transformation Rank Transformation Transact3:40:55
Normalizer Transformation Source Qualifier Transformation Stored Procedure Trans3:17:08
Learn how to design mappings in Informatica PowerCenter using source qualifier, normalizer, and stored procedure transformations, with bridge strategy, insert/update/delete/reject rules, and lookups for robust data loading.
Numeric functions String Functions Date Functions Conversion Functions Cleansing3:19:47
Unconnected lookup Transformation Unconnected Stored Procedure to Create and Dro1:58:36
Session Command EMAIL Timer3:14:40
Explore Informatica Power center session properties and commands, including configuring email notifications on success or failure, session dependencies, and event-driven timers, with hands-on examples of mapping and logs.
Event Wait Event Raise Decision Assignment Control Worklet3:17:19
Explore event wait, raise, decision, assignment, and worklet concepts in Informatica power center real-time workflows. Learn mapping, sessions, workflows, exporting, backups, testing, and tuning for reliable data integration.

Requirements

SQL Knowledge

Description

Faculty: Informatica Certified consultant

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 and3)
Hierarchy
Confirmed Dimension
Fact less Fact Table.
Summary / Aggregations table
Change Data capture

Power Center 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

Power Center 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
Mapplet and Types of Mapplets
Defining Reusable Transformations.
User Defined Functions
Tasks And Types of Tasks
Worklet 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 LookUp Caches

Static LookUp Cache
Dynamic LookUp Cache
Persistence lookup Cache
Shared LookUp Cache
Sorter and Rank Cache

Task Types

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

ETL Testing

UNIT Testing
System Integration testing
PERFORMANCE TESTING
ETL Performance Optimization techniques

Who this course is for:

any one want to learn Informatica power center and ETL