OpenCart Templates
Vaishnot IT Online Training

Informatica Online Training Course Details

Informatica deals with components that form a tool-set for establishing and maintaining data warehouses pertaining to the particular enterprise. The various components include product documentation, velocity methodology and technical support. All the three components are used in product based and services based corporate.

Informatica online training deals extensively about the major PowerCenter components for development. They are PowerCenter architecture, PowerCenter client tools and monitoring the workflow manager.

Informatica course is designed to build basic ETL mappings and mapplets while enabling the students to create, run and monitor workflows. The parameters of mapplets like load product daily aggregate table, review and real time issues are a part of the curriculum designed by experts.

Informatica training briefs about the various troubleshoot most problems and explain about the available options for loading target data.

Informatica online training introduces data warehousing concepts, modeling, changing dimensions and meta data.

Informatica course helps in understanding about the source qualifier that includes source qualifier transformation, project overview, load payment staging table, source qualifier joins, load product staging table, source pipelines, load dealership and promotions staging table for real time issues.

Informatica training by experts reveals about the expression, filter, file Lists, workflow scheduler, lookups and reusable transformations, debugger, sequence generator, router, dynamic lookup and error logging.

Prospects of Informatica:

Where ever there is a need to address the alignment of IT and business strategies Informatica is dominant. Corporate that utilize data integration software hire these professionals.

Managements look up to them for maximizing return on data to drive their top business imperatives and fully leverage their information assets residing on-premise, in the Cloud and across social networks.

Informatica professionals handle and monitor the expression, filter, file Lists, workflow scheduler, lookups and reusable transformations, debugger, sequence generator, router, dynamic lookup and error logging.

This course gives an insight into the set of software applications that help companies improve activities across multiple operating systems.


Informatica Online Training Course Topics 

Duration: 4 –  5 Weeks


Data warehouse basics

  • OLTP System
  • Data warehouse
  • Different Definitions of data warehouse
  • Difference between OPERATIONAL DS AND DWH
  • Types of ETL
  • Data Extraction
  • Types of Data loading
  • Data Aggregation
  • Data warehouse Approaches
  • Top down approach and Bottom up approach
  • DW Life cycle
  • DW-database design
  • Star schema and Snow flake schema
  • Facts and dimensions
  • Types of Dimensions
  • Types of fact table
  • Types of Olap


Informatica Power Center

Power center Installation&Administration

  • Informatica Power center architecture
  • Power center components
  • ETL Plan
  • Power center 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 Folders

Using the designer

  • Creating Source Tables.
  • Creating Target Definitions.
  • Creating Target Tables
  • Creating a Pass-Through Mapping
  • Creating source definitions
  • Creating a Mapping
  • Connecting Transformations

Transformation Creation

  • Using Transformations
  • Active and passive transformations
  • Aggregator Transformations
  • Sorter Transformations
  • Filter Transformation
  • Joiner Transformation
  • Lookup Transformation
  • Normalizer Transformation
  • Rank Transformation
  • Router Transformation
  • Sequence Generator Transformation
  • Expression Transformation
  • Sorter Transformation
  • Source Qualifier Transformation
  • Stored Procedure Transformation
  • Union Transformation
  • Router Transformation
  • Extraction of data from flat files
  • Connecting the Target
  • Designer Tips.
  • Using the Overview Window
  • Arranging Transformations
  • Creating the Session
  • Creating the Workflow
  • Creating a Mapping with Fact and Dimension Tables
  • Creating a Filter Transformation
  • Creating a Sequence Generator Transformation
  • Creating a Stored Procedure Transformation
  • Completing the Mapping
  • Creating a Workflow
  • Creating a Link Condition.
  • Running the Workflow

Using the workflow manager

  • Connecting Transformations
  • 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
  • Running the Workflow

Workflow Tasks

  •  Session
  •  Assignment task
  • Link task
  • Event raise task
  • Event wait task
  • Timer task
  • Post session and Pre-session commands
  • Session recovery
  • Commit points
  • Creation of Parameter file
  • Mapping and session parameter

Performance tuning in ETL

  • Various optimization techniques
  • Pushdown optimization
  • Incremental aggregation

Administration related tasks

  •  Taking backups
  •  Creating users
  •  Security
  •  Code migration