Informatica

 

 1.Data warehouse basics

  • OLTP System
  • Data ware house
  • Different Definitions of data warehouse
  • Difference between OPERATIONAL DS AND DWH
  • Types of ETL
  • Data Extraction
  • Data Transformation
  • Data Merging
  • Data Loading
  • Types of Data loading
  • Data Aggregation
  • Data warehouse Approaches
  • Top down approach and Bottom up approach
  • DW Life cycle
  • DW-database design
  • Star schema and Snow flake schema
  • Dimensional modeling
  • Facts and dimensions
  • Granularity
  • Types of Dimensions
  • Types of fact table
  • Types of Olap

2.Informatica Power Center 8.6 Power center Administration

  • Informatica Power center architecture
  • Power center components
  • ETL Plan
  • Power center Clients
  • Designer
  • Workflow manager
  • Work Flow monitor
  • Workflow manager
  • Repository manager
  • Power center repository
  • Administrative tool
  • Repository services
  • Integration services
  • Power center domain
  • Application services
  • Concept of nodes and grid
  • Service manager
  • Power center administration console

3.Repository Administration

  • Creating Repository Users and Groups .
  • Connecting to the Repository.
  • Creating a Group
  • Assigning Privileges to a Group.
  • Creating a User
  • Creating a Folder
  • Folder Permissions
  • Creating Folders

4.Using the designer

  • Creating Source Tables.
  • Creating Target Definitions.
  • Creating Target Tables
  • Creating a Pass-Through Mapping
  • Creating source definitions
  • Creating a Mapping
  • Connecting Transformations

5.Transformation Creation

  • Using Transformations
  • Creating a Mapping with Aggregate Values
  • Active and passive transformations
  • Creating an Aggregator Transformation
  • Creating an Expression Transformation
  • Creating a Lookup Transformation
  • Connecting the Target
  • Creating the Session
  • Creating the Workflow
  • Creating a Mapping with SCD Type 1 and SCD Type 2
  • Creating a Filter Transformation
  • Creating a Sequence Generator Transformation
  • Creating a Stored Procedure Transformation
  • Completing the Mapping
  • Creating the Target
  • Creating a Mapping with
  • Creating an Expression Transformation
  • Creating Router Transformations
  • Completing the Mapping
  • How to monitor loads 
  • Use of Workflow monitor

6.Using the workflow manager

  • Connecting Transformations
  • Creating Sessions and Workflows
  • Configuring Database Connections in the Workflow Manager
  • Creating a Reusable Session
  • Creating a Workflow
  • Running and Monitoring Workflows
  • Opening the Workflow Monitor

7.Workflow Tasks

  • Session
  • Assignment task
  • Link task
  • Event raise task
  • Event wait task
  • Timer task
  • Post session and Pre-session commands
  • Session recovery
  • Commit points
  • Creation of Parameter file
  • Mapping and session parameter

8.Performance tuning in ETL

  • Various optimization technique
  • Pushdown optimization
  • Incremental  aggregation