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