Informatica Training

Share course

DATA WAREHOUSE CONCEPTS

  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture(Basic)
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Slowly Changing Dimensions and its types.
  • Dimension
  • Fact
  • Hierarchy
  • Confirmed Dimension
  • Fact less Fact
  • Summary / Aggregations table
  • Change Data Capture

ETL INFORMATICA POWER CENTER 9:

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
  • Target
  • 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 Workflow
  • 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
  • Push Down Optimization
  • PMCMD Utility
  • PMREP Utility
  • Incremental Aggregation
  • Types of LookUp Caches
  • Static LookUp Cache
  • Dynamic LookUp Cache
  • PMREP Utility
  • Perisistance lookup Cache
  • Shared LookUp Cache

 

 

Key Highlights

 

  • PSN Trainings is a leading online training provider across the globe. Our online training team is highly qualified, experienced and skilled with real time  industry experience.

PSN Trainings Highlights:

 

  • Instructor Led Online Courses  with 24x7 On-Demand Support
  • World Class Trainers with +12 years Industry Experience. Instructors are not just trainers they are Consultants
  • We provide  24/7 Server access to help our trainees practice exercises
  • Teaching Material Prepared by Experts from PSN Trainings who have real time experience
  • Hands on Lab Assignments
  • 100% Placement Assistance
  • Project Based learning to get hands-on experience on a real life application!
  • Providing high quality interactive and cost effective online Training
  • Live Interactive classes by industry experts.

Trainer Information:

  • Having 8  years of  IT Industry Experience
  • 6  years  of real time  Informatica and DWH Experience
  • Having  4 years experience  as an online trainer for Informatica
  • Held up to 60+ batches in past 4 Years
  • Trainer has an excellent Practical & industrial knowledge
 I learned Informatica 9.5.1 which is   latest version in market.Trainer helped me in Informatica 9.5.1 installation.For each topic we did lab exercises and covered advanced topics like GRID and Pushdown Optimization with real time examples.
 Priyanka
 

 

Excellent Trainer with 10 Years of real time experince in Informatica and DWH Tools.other than technical, i got real time training in Informatica.Thanks to PSN Trainings.
 Sai Kiran
 

 

After attending so many demo classes from different online Training Institutes i impressed with   PSN Trainings Informatica Demo and continued Informatica 9.5.1 Online Training. I strongly suggest PSN Trainings for Informatica Online Training.
 Satya Mishra
 

 

Enquiry