Informatica

What you will learn

Ab Initio Server Hardware

Ab Initio Installation

Ab Initio Data Profiles

Ab Initio File Systems and Heterogeneous Database Systems

Ab Initio Data Integration Design Specifications

Ab Initio Application Graphs

Ab Initio Application Test Plan

Ab Initio Graph Development Standards Checklist

Ab Initio Lifecycle Migration

Ab Initio Application Operations

Introduction to Data warehousing

What is Data warehousing?

Who needs Data warehouse?

Why Data warehouse is required?

Types of Systems

(i) OLTP

(ii) DSS

Maintenance of Data warehouse

Data warehousing Life Cycle

Data warehousing Testing Life Cycle

Data warehousing Architecture

Source

Integration Layer

Staging Area

Targets

Analysis & Reporting

ODS

Data Modeling

Introduction

Different phases of Modeling

Multi Dimensional Modeling

What is a Dimension?

What are Facts?

Multi Dimensional Model

Hierarchies

OLAP

MOLAP

ROLAP

HOLAP

Cubes and its Functions

Star Schema

Fact Table

Dimensional Tables

Snow flake Schema

Factless Fact Table

Confirmed Dimensions

Informatica 8.6

Introduction to Informatica

Overview

Basic Definitions

Informatica Products

Informatica Architecture

Tools and their roles

Folders - Sub Folders

Informatica Designer - Introduction

Introduction to designer

Designer interfaces

Designer tools

Defining Sources

(i) Database as a source

(ii) Flat Files sources

Defining Targets

(i) Importing from database

(ii) Creating a new target

(iii) 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 Transformation

SQL override in Source Qualifier Transformation

Mapping Source Qualifier as Filter

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 Transformation

Union Transformation

XML Transformation

Mapping Wizards

Implementing Type-I, Type-II and Type-III mappings

Informatica Workflow Manager

Workflow Introduction

Tasks

Workflow Tools

Connections

Defining Tasks

Command Task

Email Task

Session Task

Link Conditions (v) Event Wait & Event Raise

Setting properties of Session Task

Creating Workflow

Starting Workflow

Monitoring Workflow

Informatica Advanced Features

Incremental Aggregation

Mapping Analyst for Excel (MAE)

Push-down Optimization

Mapplet Implementation

Target Load Plan

Constraint Based Loading

Mapping Parameters

Mapping Variables

Session Parameters

Link Conditions

Meta Data Backup & Restore

Copying Repository

Deleting Repository Contents