INFORMATICA 8.6 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 8.6(Admin & Development) Online Training Course Content
  • Informatica Admin :
    • Understanding Domains and Nodes and grids.
    • Installation and up gradation of Informatica Server and Client in windows and linux server.
    • Managing user account (presently logged in user).
    • Using Informatica Administrator (Domain tab, Logs tab, Reports tab, Monitoring and security tab).
    • Domain Management.
    • Creation of Application services.
    • Application services upgrade.
    • Users and Groups, roles and privileges.
    • Analyst Service.
    • Power center Repository Service
    • Power Center integration Service.
    • Model repository service.
    • Data Integration Service.
    • Content Management Service.
    • Power Exchange Listener Service.
    • Power Center Logger Service.
    • Web Services Hub.
    • Reporting Service.
    • Reporting and Dashboards.
    • SAP BW Service.
    • Connection Management.
    • Domain Object Export and Import.
    • Domain backup and restore.? INFA commands (pmrep and pmcmd).
    • Restoring and backup and upgrade of repository contents.
    • License Management.
    • Monitoring Services.
    • Globalization.
    • Code Pages.
    • Connecting to Databases in power Center.
    • Security Concepts.
    • Versioning.
    • Copy paste of the Domain object.
    • Deployement.
  • Informatica Devlopment :
    • Introduction
    • Data Warehouse / Data Mining / ETL Basics
    • PowerCenter Components and User Interface
    • PowerCenter Architecture
    • SOA and PowerCenter Architecture
    • PowerCenter Client Tools
    • Mapping, Sessions, and Workflow Basics, Transformations
    • Importing Sources and Targets
    • Creating Mappings, Sessions, and Workflows
    • Running the Workflow.
    • Sorter Transformation.
  • Expression, Filter, Router Transformations, and File Lists
    • Sorter Transformation
    • Expression Editor
    • Filter Transformation, File Lists
    • Router Transformation
  • Joins, Features and Techniques
  • Joiner Transformation
  • Merging Data
  • Aggregator, Rank and Sequence generator Transformations and Working with Flat Files
    • Aggregator Transformation
    • Rank Transformations
    • Working with Flat Files
    • Sequence Generator Transformations
  • Union, Joiner, and, Expression Transformations and File Debugger
    • Expression Transformation
    • Union Transformation
    • Joiner Transformation
    • Active and Passive Transformations
    • Data Concatenation
  • Source Qualifier, Stored Procedure, and Transaction Control Transformation
    • Source Qualifier Transformation
    • SQL OverrCSRC IND
    • Stored procedure Transformation
    • Transaction Control Transformation
  • Lookup (Connected and Unconnected) and Normalizer Transformation
    • Lookup Transformation
    • Lookup Override
    • Connected Lookup
    • Unconnected Lookup
    • Lookup Cache(Static, Dynamic and Persistent)
    • Normalizer
  • Update Strategy Transformation
    • Designing Workflows
    • Workshop about complex Workflows
    • Any clarifications on transformations
    • File Merging
    • Batch Processing
    • Target Load Plan
  • Mapplets, Worklets and More Tasks
    • Worklets
    • Session Parameters
    • Mapping Parameters
    • Mapping Variables
  • Mapping Design
    • Designing Mappings
    • Workshop about mapping designer
    • Slowly Changing Dimensions (SCD)

Please Register with us