Search for Training

Informatica

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.

Course Content


Introduction

  • Overview
  • Basic Definitions
  • Informatica products
  • Informatica Architecture
  • Tools and their roles
  • Folders-Sub folders
  • Power center / Power mart

Infomatica Designer – Introductiion

  • Introduction to Designer
  • Logon to Designer
  • Designer interfaces
  • Designer Tools
  • Defining Sources
  • Database as a source
  • Flat File sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects

Informatica Designer

  • Mapping Introduction
  • Source Qualifier
  • Ports
  • Mapping – Table to Table
  • Mapping Flat File to Table
  • Connected /Unconnected Transformations
  • Active and Passive Transformations
  • Source Qualifier to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored Procedure Transformation(Connected and Unconnected)
  • Union Transformation
  • XML Transformation
  • Mapping Wizards
  • Implementing Type-I,Type-II,Type-III Mappings

Informatica – Workflow Manager

  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connetions
  • Defining tasks
  • Command Tasks
  • Email Task
  • Session Task
  • Link Conditions
  • Event Wait & 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 Variable
  • Session Parameters
  • Link Conditions
  • Reusable Transformation
  • Task and Types of Tasks
  • Work let and Types of work lets
  • Scheduling Workflow
  • Control flow using Command task and event wait task
  • Incremental Loading

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

What is the sum of 8 + 2? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234


Our Initiatives

ExpertsCertify - Skill Assessment And Tests
AreuCertified - Certification Training
Xpertised IT Solutions - Custom Application Development
Xpertised Learning - Redefine Skills

Subscribe to our weekly newsletter

Batch Details
  Request a Callback
Call us at: +91 7259222234