Datawarehousing Informatica Online Training

  • INFORMATICA OVERVIEW
    • History of Informatica
    • Opportunities of Informatica
    • Other ETL tools
    • Power centre Administration
    • Informatica Power centre architecture
    • Power centre components
    • ETL Plan
    • Power centre 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
    • 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 shortcuts
  • DESIGNER
    • Types of Transformations
    • Connected and Unconnected Transformations
    • Active and Passive Transformations
    • Creating Source Tables
    • Creating Target Definitions
    • Creating Target Tables
    • Creating source definitions
    • Creating a Mapping
    • Connecting Transformations
    • Transformation Creation
    • Importing sources and targets (database objects)
    • Importing sources and targets (flat files and XML files)
    • Using Transformations
    • Aggregator Transformation
    • Expression Transformation
    • Lookup Transformation (Connected and Un Connected)
    • Union Transformation
    • Joiner Transformation
    • Normalizer Transformation
    • SQL Transformation
    • Filter Transformation
    • Sequence Generator Transformation
    • Source Qualifier Transformation
    • Router Transformations
    • Rank Transformations
    • XML Parser Transformation
    • XML Generator Transformation
    • SQL Override in source qualifier Transformation and lookup Transformation
    • Connecting the Target
    • Connecting Transformations
    • Creating a Mapping
    • Completing the Mapping
    • Creating a Mapping with Aggregate Values
    • Target load order plan
    • Mapping wizards
    • Reusable Transformation
  • WORKFLOW MANAGER
    • Creating the Session
    • Creating the Workflow
    • Using the workflow manager
    • 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
    • Workflow Tasks
    • Session
    • Assignment task
    • Link task
    • Post session and Pre-session commands
    • Commit points
    • Mapping and session parameter
    • Pushdown optimization
  • WORKFLOW MONITOR
    • How to monitor loads
    • Uses of Workflow monitor
    • Monitoring the jobs
    • How to get Session Logs and Workflow Logs
    • Real time Questions and Answers
    • Exercises for each Transformation
    • Datawarehosuing Concepts