Informatica

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Informatica which gives you the opportunity to interact with a Informatica instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants. Understand Informatica PowerCenter Architecture Understand the implementation of workflow and sessions for recovery Master ETL and Data Integration concepts Understand Informatica Administrator Tools Understand about Repository Manager Learn to indentify the Network Errors and Connection Work with a command line of Informatica Understand PowerCenter Environment Work with the application services related to PowerCenter Load Dimension Tables Implement several transformations and error handling strategies

Course Content


Informatica Concepts and Overview

  • Overview and Basic Definitions of Informatica
  • Informatica Products
  • Informatica Architecture
  • Informatica Tools and roles
  • Folders -sub Folders
  • Power Centre I Power Malt

Power Center Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console

Informatica Designer – Introduction

  • Introduction to designer
  • Designer tool
  • Designer interfaces
  • Defining Sources
    • Database as a source
    • Rat Files sources
  • Defining Targets
  • Importing from database
  • How to create a new target
  • Creating target databases object

Informatica Designer- Advanced

  • Mapping Introduction
  • Source Qualifier
  • Mapping- Table to Table
  • Mapping flat file to Table
  • Ports
  • Connected/ Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • Mapping Source Qualifier as Filter
  • SQl Override-Source Qualifier Transformation
  • Source qualifier to join Data
  • Filter Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored procedure Transformation
  • XMl Transformation
  • Expression Transformation
  • Union Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III and Mappings

Informatica- Workflow Manager

  • Introduction to Workflow
  • Workflow tools
  • Tasks
  • Connections

Working with Tasks

  • Email Task
  • Command Task
  • Session Task
  • Link Conditions
  • Event Wait and Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow

Informatica Advanced Features

  • Incremental Aggregation
  • Mapplet implementation
  • Target Load Plan
  • Constraint-based Loading
  • Mapping Parameters
  • Mapping Variables
  • Sessions parameters
  • Link Conditions

 Sources

  • Working with relational Sources
  • Working with Flat Files
  • Targets
  • Working with Relational Targets
  • Working with Flat file Targets

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234