USA: +1-515-337-8778
India: +91-8008527566
info@sryitsolutions.com

Informatica

What is Informatica?

Informatica is Engine driven ETL tool mostly used in Data Integration and Data warehouse environment. It is supported on different environments ( UNIX, WINDOWS, MAINFRAME etc).

Informatica Online Training Contents

Informatica Training Details

Blog

Introduction

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

Infomatica Designer – Introduction

  • 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
  • Connections
  • 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

 

Course Details:

Duration : 30-35 hours (Daily 1 hr to 1 hr 30 minutes)
System Access: 60 days
Session Timings: As per participant convenience
Payment Options: Paypal

Why SRYIT:

We are having ample of experience in Informatica Online Training. After every session recordings will be provided and soft copy of Informatica Online Training material will be provided. After the sessions of Online Training project support will be provided. CV preparation will be done with the ongoing clients. We are maintaining the Blogs for every course which will have the blogs related to new concepts of Informatica Online Training.

About the Trainer:

Informatica Online Training will be provided by real time certified consultant. Overall experience of trainer is 8 years. Trainer is having good experience in corporate training. Trainer is an expert in implementation projects and Informatica Online Training support projects. In the Informatica Online Training real time scenarios will be covered which helps the job seeker to handle the projects easily.

 Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn Informatica Online Training.

To know more details about INFORMATICA visit our blog

Open Popup
  • Book Your Demo.