Close

INFORMATICA

Informatica is powerful ETL tool from Information Corporation, a leading provider of enterprise data integration software and ETL softwares. In informatica, all the Metadata information about source systems,target systems and transformations are stored in the Informatica repository. Informatica’s Power Center Client and Repository Server access this repository to store and retrieve metadata..

Length : 45 Hours

Data Warehouse and ETL Concepts

What is Data ware House

Characteristics of the Data ware House

OLTP Vs OLAP

Dimensions Tables Vs Fact Table

Advantages of Data ware House

Data Marts

Data ware House Vs Data Mart

Data Extraction

Data Transformation

Data Loading

Overview of ETL Architecture

Data Staging Area

Database Designs(Star Schema, Snowflake Schema etc)

Database Concepts

What is Database

DDL,DML,DCL AND TCL

Set Operators

Sub Queries

Group By and Having Clause

Joins

Power Centre Components

Informatica Architecture

Designer

Repository Manager

Workflow Manager & Workflow Monitor

Informatica Concepts and Overview

Source Qualifie

Target Designer

Transformations

Mappings &Mapplets

Sessions

Workflows & Work lets

Sources

Working with Relational Sources

Working with Flat Files (Direct/Indirect)

Targets

Working with Relational Targets

Working with Flat file Targets

Transformations

Active and Passive Transformations

Connected and Unconnected Transformations

Implementation of Slowly Changing Dimensions

Type-1

Type-2

Type-3