INFORMATICA ADVANCED ONLINE TRAINING

Training 24x7 Provides Informatica Advanced Online Training Informatica's product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging; currently at version 9.6 These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies.

Informatica Advanced Online Training Course Content
  • Informatica Concepts and Overview
    • Data Warehousing concepts
    • ETL Concepts.
    • Informatica Architecture
  • Power Center Tools
    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
  • Basic Concepts and Components
    • 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
    • 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
  • Advanced Informatica Concepts
    • Unconnected lookup Transformation
    • Mapping Parameters
    • Mapping Variables
    • Target Load Plan
    • Defining Reusable Transformations.
    • Mapplets
    • Tasks And Types of Tasks.
    • Worklet
    • Scheduling Workflow
    • Types of Batch Processing
    • Link conditions
    • Defining Session Parameters
    • PMCMD Utility
  • Types Of Lookup Caches
    • Static LookUp Cache
    • Dynamic LookUp Cache
    • Perisistance lookup Cache
    • Shared LookUp Cache
  • Task Types:
    • Session
    • Command
    • Worklet
    • EMAIL
    • Timer
    • Event Wait
    • Event Raise
    • Decision
    • Control
  • Informatica Architecture and components
    • Domain , Node,Master Gateway Node
    • Services (Integration Service,Repository Service,DIS,CMS,MRS etc)
    • Administrator Tool Overview, User,Role Group creation.
  • Performance Tuning
    • Approach and Concepts
    • Partitioning,Dynamic Partitioning
    • Ways to handle different bottlenecks with example
  • Push Down optimization
    • Types of PDO
    • Transformations supported
    • What are views created for PDO etc
  • ETL Auditing
    • Whats is ETL auditing and need of it
    • Different ways of ETL auditing (PMERROR tables, Pmcmd commands,Repository queries etc)
  • Automation using Informatica PC
    • PMCMD command usage
    • XML generation
  • Incremental aggregation
  • Concurrent Workflows
  • Workflow Recovery
  • External Loading

Please Register with us