Home Courses Offered BUSINESS INTELLIGENCE / ANALYTICS Course Details
 

INFORMATICA POWERCENTER

 SELF PACED ON-DEMAND COURSE ONLY 
 
Course to Maximize your ETL skills to make foray into the Data Integration Area in BIG DATA, BI & ANALYTICS World!
 
Target Audience: IT Developers, BI Analysts, Data Analysts, Business Analysts, Quality Analysts and Beginners with Basic SQL Knowledge.
 
 
 
MODULE-1: INTRODUCTION & ARCHITECTURE
  • PowerCenter 9.X Architecture
  • Components Connectivity & Data Flow
  • Meta Data Repository
 
MODULE-2: INSTALLATION & CONFIGRATION
  • Installation Steps Overview
  • Repository and Integration Services & Client Tools Configuration
  • Admin Console, Client Components and Functions
 
MODULE-3: ADMINISTRATION & CLIENT TOOLS
  • Users, Groups, Roles and Privileges
  • Folder Permissions & Security Drilldown
  • Designer
  • Workflow Manager
  • Workflow Monitor
  • Repository Manager
 
MODULE-4: SOURCES
  • Source Types & Properties
  • Flat Files/Relational/XML/Cobol
  • Metadata Extensions
 
MODULE-5: TARGETS
  • Target Types & Properties
  • Target Load Options
  • Target Load Plan
  • Reject Row Handling Options
  • Constraint Based Load
  • Direct/In-Direct Load
 
MODULE-6: TRANSFORMATION CONCEPTS
  • Transformation Types, Features and Ports
  • Informatica Functions and Data types
  • Copy & Shortcuts
 
MODULE-7: MAPPINGS
  • Mapping Components, Validation and Data Flow Rules
  • Pre SQL and Post SQL
  • Object Export and Import
 
MODULE-8: TRANSFORMATIONS
  • Expression Transformation
  • Source Qualifier Transformation
  • Filter Transformation 
  • Router Transformation
  • Joiner Transformation
  • Sorter Transformation
  • Aggregator Transformation
  • Rank Transformation
  • Normalizer Transformation (Columns to Row Conversion)
  • Aggregator (Rows to Columns Conversion)
  • Sequence Generator Transformation
  • Lookup Transformation (Connected & Un-connected)
  • Lookup Caches (Static/Dynamic/Persistent/Shared)
  • Update Strategy Transformation
  • Stored Procedure Transformation (Connected and Un-connected)
  • Transaction Control Transformation
  • Union Transformation

 

MODULE-9: RE-USABLE TRANSFORMATIONS & MAPPLETS

  • Reusable Transformations
  • Mapplets
 
 
MODULE-10: DEBUGGER
  • Debugger Features & Steps
  • Debugger Windows & Indicators

 

MODULE-11: WORKFLOWS & MONITORING

  • Workflow Tools
  • Workflow Connections (Relational/FTP etc.) and Properties
  • Workflow Design and Properties
  • Concurrent and Sequential Workflows
  • Session Configuration
  • Workflow Monitor Tools and Properties
  • Actions Initiated from the Workflow Monitor

 

MODULE-12: TASKS & WORKLETS

  • Command
  • Decision
  • Assignment
  • Email
  • Event Wait
  • Event Raise
  • Timer
  • Control
  • Reusable Tasks
  • Worklets
 
MODULE-13: ADVANCED CONCEPTS
  • Mapping Parameters & Variables
  • Workflow Variables and Session Parameters
  • Parameter Files
  • Performance Tuning
  • Partitioning
  • Incremental Aggregation
  • Pushdown Optimization
  • Versioning & Production Migration
  • Batch Execution (PMCMD) Commands
  • Slowly Growing Dimension & Slowly Changing Dimensions - Type 1, 2 & 3 Mappings Creation using Mapping Wizard

 

MODULE-14: ASSIGNMENTS & STUDENTS PRACTICE
  • Oracle Database Installation
  • TOAD for Oracle
  • 20 Assignments with Real Time Scenarios
 
Classes: 22-25 Hours
 
Lab Sessions: 40 Hours
 
Self Paced On-Demand Videos & Material FEE: $150
 
 
***As per the tutor's discretion, some of the provided course content may be altered/omitted to suit the class needs***
 
**Products and Logos Mentioned are Trademarks of Informatica Corporation and the Respective Companies**
 
 






Please contact us for the course details including the currently offered courses, course content, price and the schedule.

Free Demo

If you are interested to upgrade your skill-set, please consider attending one of our Real Classes as a free demo to evaluate the class quality and then decide your course of action.