Informatica Online Training

About INFORMATICA

Informatica Online Training is successful ETL and EAI tool. Over the course of last 10 years Informatica has introduced a series of products – all related to Data Integration & Warehousing. Informatica offers a rich set of features like operations at row level on data, integration of data from multiple structured, semi-structured or unstructured systems, scheduling of data operation. It also has the feature of metadata, so the information about the process and data operations are also preserved.

About Instructor

Informatica Online Training is provided by a real time consultant. The experience acquired by our trainer on Informatica, is promisingly helpful to the corporate trainee’s. Our instructors are experts in the implementation and support projects.  ASTS always works on real time scenarios. It is extremely useful for the professionals to handle the projects easily in the IT industry.

Prerequisites

  • Graduates/Post Graduates are eligible.
  • Everyone must have knowledge on SQL and PL/SQL.
  • Basic Knowledge on UNIX Shell Scripting.

Terms And Conditions

  • We will Provide Supporting to resolve Student practical Issues.
  • We will provide server Access and 100% Lab Facility.
  • Resume Preparation.
  • Interview Questions & Answers.
  • We will conduct mock interviews. Student also get 100% supporting before and after getting job.

Course Content

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

 

share this
Top ↑