Facebook Twitter google plus LinkedIn

Email:contact@psntrainings.com
india:Whatsapp No+91 86860 29160 USA:+1 228 586 3560

Informatica Training in Hyderabad



PSN Trainings is the Best informatica Online Training institute in Hyderabad,india

Course Description

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
We are offered Cognos online training also


Enquiry