INFORMATICA

  • Data Warehouse Concepts
  • Introduction to Data warehouse
  • What is Data warehouse and why we need Data warehouse
  • OLTP vs ODS vs Data warehouse
  • Dimensional modeling
  • Star schema/Snowflake schema/Galaxy schema
  • Dimensions / Facts tables
  • Slowly Changing Dimensions and its types
  • Data Staging Area
  • Different types of Dimensions and Facts
  • Data Mart vs Data warehouse
  • DWH Approaches: Ralph Kimball vs Bill Inmon
  • Informatica Power Center
  • Software Installation
  • Informatica 9 Server/Client Installation on Windows
  • Power Center Architecture and Components
  • Introduction to informatica Power Center
  • Difference Between Power Center and Power Mart
  • PowerCenter 9 architecture
  • PowerCenter 7 architecture vs PowerCenter 8 and 9 architecture
  • Extraction, Transformation and loading process
  • Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica Adminstration Console.
  • Repository Server
  • Repository maintenance
  • Repository Server Administration Console
  • Security, Repository, privileges and folder permissions
  • Metadata extensions
  • Power Center Developer Topics
  • Create a Folder
  • How to provide Privileges
  • Source Object Definitions
  • Source types
  • Relational Tables (Oracle, Teradata)
  • Flat Files (fixe width, Delimiter Files)
  • Xml Files
  • Source properties
  • Analyze Source Data, Import Source
  • Target Object Definitions
  • Target types
  • Target properties
  • Import Targets
  • Transformation Concepts
  • Transformation types and views
  • Transformation features and ports
  • Informatica functions and data types
  • Mappings
  • Mapping components
  • Source Qualifier transformation
  • Pre SQL and Post SQL
  • Mapping validation
  • Data flow rules
  • Create a Mapping, session, and workflow
  • Workflows
  • Workflow Tools
  • Workflow Structure and configuration
  • Workflow Tasks
  • Workflow Design and properties
  • Session Tasks
  • Session Task properties
  • Session components
  • Transformation overrides
  • Session partitions
  • Workflow Monitoring
  • Workflow Monitor views
  • Monitoring a Server
  • Actions initiated from the workflow Monitor
  • Gantt chart View and Task view.
  • Start and Monitor a Workflow
  • Debugger
  • Debugger features
  • Debugger windows
  • Tips for using the Debugger
  • The Debugger
  • Expression transformation
  • Expression, variable ports, storing previous record values.
  • Different type of Ports
  • Input/ output / Variable ports and Port Evaluation
  • Filter transformation
  • Filter properties
  • Expression and Filter
  • Aggregator transformation
  • Aggregation function and expressions
  • Aggregator properties
  • Using sorted data
  • Incremental Aggregation
  • Joiner transformation
  • Joiner types
  • Joiner conditions and properties
  • Joiner usage and Nested joins
  • Aggregator, Heterogeneous join
  • Working with Flat files
  • Importing and editing flat file sources & Targets
  • Lab Session – Use Flat file as source. Sorter transformation
  • Sorter properties
  • Sorter limitations
  • Sorter
  • Propagate Attributes.
  • Shared Folder and Working with shortcuts.
  • Informatica built in functions.
  • Lookup transformation
  • Lookup principles
  • Lookup properties
  • Lookup techniques
  • Connected and unconnected lookups, Lookup Caches
  • Basic and Advance Lookup Target options
  • Row type indicators
  • Row loading operations
  • Constraint- based loading
  • Rejected row handling options
  • Deleting Rows
  • Update Strategy transformation
  • Update strategy expressions
  • Data Driven Inserts and Rejects
  • Router transformation
  • Using a router
  • Router groups
  • Router Conditional Lookups
  • Usage and techniques
  • Advantage
  • Functionality
  • Straight Load
  • Conditional Lookups
  • Heterogeneous Targets
  • Heterogeneous target types
  • Target type conversions and limitations
  • Heterogeneous Targets Mapplets
  • Functionality and Advantages
  • Mapplet types and structure
  • Mapplet limitations
  • Mapplets
  • Reusable transformations
  • Advantages
  • Limitations
  • Promoting and copying transformations
  • Reusable transformations /Sequence Generator transformation
  • Using a sequence Generator
  • Sequence Generator properties
  • Dynamic Lookup
  • Dynamic lookup theory
  • Usage and functionality
  • Advantages
  • Dynamic Lookup Concurrent and sequential Workflows
  • Concurrent Workflows
  • Sequential Workflows
  • Stopping, Starting and suspending tasks and workflows
  • Sequential Workflow Additional Transformations
  • Union Transformation
  • Rank transformation
  • Normalize transformation
  • Custom Transformation
  • Transformation Control transformation
  • XML Transformation
  • SQL Transformation
  • Stored Procedure Transformation
  • External procedure Transformation
  • SQL Transformation
  • Lab Sessions- For above transformations Error Handling
  • Overview of Error Handling Topics
  • Review various BI Reporting methods
  • Informatica – Best practices
  • Mapping Design through Visio tool
  • Data Loading techniques for huge volume of data
  • XML Data Loading – Best Practices
  • Incremental Loading and Rollback procedures
  • Slowly changing dimension – Overview
  • Caching VS Direct load
  • Transaction Handling
  • Performance Tuning
  • Traceability and Event Logging
  • Error handling fatal and non Fatal Workflow Tasks
  • Command
  • Email
  • Decision
  • Timer
  • Control
  • Even Raise and Wait
  • Sequential Batch Processing
  • Parallel Batch Processing
  • Lab Sessions – With Workflow tasks Link Conditions Team Based Development
  • Version Control
  • Checking out and checking in objects
  • Performance Tuning
  • Overview of System Environment Identifying Bottlenecks
  • Optimizing Source, Target, mapping, Transformation, session
  • Mapping Parameters and Variables
  • Introduction to Mapping Variables and Parameters
  • Creating Mapping Variables and Updating Variables
  • Creating Parameter File and associating file to a Session
  • System Variables
  • Variables functions
  • Override Mapping Variable with Parameter Files
  • Dynamically Updating a Source Qualifier with Mapping Variable
  • Slowly Changing Dimensions Type 1, Type 2, Type 3
  • Incremental Loading
  • SCD 1, 2, 3
  • Reusable Workflow Tasks
  • Worklets
  • Worklets Limitation
  • Sessions
  • Reusable Sessions
  • Create Worklets using Tasks Command Line Interface ( PMCMD)
  • Overview of PMCMD and functions
  • Overview of PMREP and functions
  • PMCMD
  • PMREP
  • Informatica Migrations:
  • Copying Objects
  • Objects export and import (XML)
  • Deployment groups
  • Workflows Scheduling
  • Using Informatica
  • Unix crontab, third party tools
  • Informatica Project- Case Study
  • Sales Data mart
  • Loading Dimensions and Facts
  • ETL Best Practices and methodologies
  • Review the Industry best practices in ETL Development
  • Review Real time project experiences of trainer
  • Discuss what is learned techniques are useful in real world
  • How to design effective ETL process
  • Important considerations in designing ETL process
  • Discuss real world production issues and support
  • Discuss various roles in ETL world
  • Business Analyst, System Analyst
  • System Architect
  • Technical Architect, ETL Lead
  • Stakeholders, Business users
  • Effective ways of using Data warehouse

Course Video

The Course Videos Section.

Course Overview

The Course Overview Section.