Knowledge for great careers

      COURSE CONTENT




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 and3)
·         Hierarchy
·         Confirmed Dimension
·         Fact less Fact Table.
·         Summary / Aggregations table
·         Change Data capture


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

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

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 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 LookUp Caches
·         Static LookUp Cache
·         Dynamic LookUp Cache
·         Persistence lookup Cache
·         Shared LookUp Cache
·         Sorter and Rank Cache

Task Types
·         Session
·         Command
·         EMAIL
·         Timer
·         Event Wait
·         Event Raise
·         Decision
·         Assignment
·         Control
·         Worklet

ETL Testing
·         UNIT Testing
·         System Integration testing
·         PERFORMANCE TESTING
·         ETL Performance Optimization techniques