Data Warehousing - Informatica Concepts

In general, information takes the major role in any busingess. either that information can be in any format like documents or data. As the organizations are expanding, the volume of the information become highly difficult to store because of the data stored in various places. If management people wanted to take important decisions in such scanario, it is much complex to devote such a huge amount of time to organize the information.
in this case, information management involves to gather and manage information various sources and unifying then into a single format. so that it becomes easily accessible to the right people at right time. that it becomes easily accessible to the right people at the right time.

There are two parts in Data Warehousing:
1. Extraction, Transformation and and Loading
2. Business Intelligence Reporting

ETL Tools: Informatica, Datastage, SSIS, Abinitio,
BI Tools : SAP-Business Objects, Crystal Reports, Hyperion, Cognos

Objective: This course is designed to teach data warehousing concepts and to build Data Warehouse using Informatica.

Training Topics:

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
Power center / Power mart
Differences between 7x and 8x

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
(i)Command Task
(ii)Email Task
(iii)Session Task
(iv)Link Conditions
Setting properties of Session Task
Creating Workflow
Starting Workflow
Monitoring Workflow

Informatica Advanced Features
Incremental Aggregation
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
Sending Notification Messages

Even there are lot of Data Warehousing tools using in industries, it is getting difficult for trainees to gain the accurate information about these tools and how they match upto specific requirements. So it is always a challenge of which appropriate tool to choose to fulfil the requirement. But in our Embedded Wings, We have strong experience and expertize in most of data warehousing tools and certainly we can help you make the right choice through evaluations, proof of concept and benchmarks.

Embedded Wings, Visakhapatnam, India is an ISO 9001:2008 certified training institution offering a training on various data warehousing technologies. With our expertize in the field of data warehousing training and our world-class virtual learning solutions, Embedded Wings offer you training to your specific needs.

We offer the below Data Warehousing tools in our institution,

ETL Tools : Informatica, Abinitio, BODI, Data Stage
BI Reporting Tools: SAP-Business Objects, Hyperion, Microstrategy, OBIEE
SAP : FI-CO, BI/BW, Basis
Other Tools : SAS, TeraData
Other Technologies : MATLAB, DSP, DIP, Simulink, Labview, Simulation

Online Training Methodology:
Instructor led online remote classes, Voice through Conference Calls, Presentation through Web Access, and limited number of student per a batch with personal care on each candidate.

Online Training Highlights at Embedded Wings:
* Interactive Learning at Learners convenience time.
* Training provision by Industry experts.
* You can learn from your own place.
* Post training support like Resume Preparation, Interview assistance and Placement assistance.