Informatica 8.6 Course

Informatica PowerCenter and PowerConnect Adapters.

Informatica 8.6(Admin & Development) 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.

What you will learn

Use a softlink in UNIX for any of the Informatica directories. To configure INFA_HOME so that any Informatica application or service can locate the other Informatica components it needs to run, set INFA_HOME to the location of the Informatica installation directory.

  • Informatica Admin Overview
  • Informatica Development Overview

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)
Back to top