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