Informatica Powercenter 9.x
Prerequisite for this course
-
SQL beginner course
-
Unix basis commands
-
Data warehouse basics
Installation
-
Pre-build VMware setup
-
Informatica Client-Server setup guide on personal system
Transformations
-
What Is Transformation
-
Types of Transformation
-
Active Transformations
-
Passive Transformations
-
-
Ports in informatica
-
Connection setup in designer and workflow manager
-
Expression Transformation
-
Filter Transformation
-
Router Transformation
-
Sorter Transformation
-
Rank Transformation
-
Source Qualifier Transformation
-
Aggregator Transformation
-
Joiner Transformation
-
Sequence Generator Transformation
-
SQL Transformation
-
Stored Procedure Transformation
-
Lookup (Different Type of Lookup) Transformation
-
Union Transformation
-
Transaction control transformation
-
Normalizer Transformation
-
Update Strategy Transformation
Implementations
-
SCD Type-1
-
SCD Type-2(Date, Flag and Version)
-
SCD Type-3
-
Incremental Aggregation
-
Change data capture
Workflow Manager
-
Create Reusable Tasks
-
Workflows, Sessions
-
Task
-
Session
-
Link task
-
Decision Task
-
Control Task
-
Event Wait Task
-
Timer Task
-
Monitoring Workflows and Debugging Errors
Advanced topics
-
Indirect Loading
-
Constraint Based Load Ordering
-
Target Load Plan
-
Worklet, Mapplet
-
Session properties
-
Reusable Transformation
-
Migration
-
Scheduling Workflow
-
Parameter and Variables
-
Performance Tuning
-
Partition
Informatica Intelligent cloud services – Introduction and roadmap
-
Informatica Cloud Overview
-
Informatica Cloud Secure Agent and Architecture
-
Creating Connections
-
Data Synchronization Application
-
Data Replication Application
-
Cloud Mapping Designer
-
Task flows
-
Performance and Scalability