INSTEP

Data Warehousing Training program in Bangalore :: 100% Placement Assistance :: Call 080-30520488/89

Contact: instepglobal@... for details

Ph: 080-30520488/89

 

Data Warehousing Concepts

Informatica

Business Objects

COGNOS

 

Introduction to Data Warehousing Course

What is Data Warehousing –Overview?

Who needs Data Warehouse?

What do you get at InStep?

 

Data Warehousing

What is Data Warehousing?

 

Data Warehousing

Who needs Data Warehouse?

Types of systems

      i. OLTP            ii. DSS

 

Data Warehouse Architecture

Source

Integration Layer

Staging area

Cubes

Analysis and Reporting

Data Mining

Aggregates

ODS

 

Data Modeling

Introduction

Different Phases of Data Modeling

Normalisation

      I   Normal Form

      II  Normal Form

      III Normal Form

 

Multi Dimension Modeling

What is a Dimension?

What are Facts?

Multi Dimensional Model

Hierarchies

OLAP

Cubes and its Functions

 

Multi Dimensional Modeling

Star Schema

Fact Table

Dimensional Tables

Snow Flake Star Schema

Star Flake Star Schema

Single Source

Multiple Sources     

 

Informatica

Back to Top 

Introduction to Informatica

Overview

Basic definitions

Informatica Products

Informatica Architecture

Tools and their roles

Folders – sub folders

Power Center/Power Mart

 

Informatica Designer

Introduction to designer

Logon to designer

Designer tools

Defining sources

i.         Database as a sources

ii.       Flat Files as sources

Defining Targets

      Importing from database

      Creating a new target

      Creating target database objects

 

Informatica Designer

Mapping Introduction

Code Page

Source qualifier

Ports

Mapping –Table to Table

Mapping –Flat file to Table

Mapping Source Qualifier as a Filter

 

Informatica Designer

Source qualifier to join Data

Sequence Generator Transformations

Connected/Unconnected Transformations

Active and Passive Transformations

Mapping using Sequence Generator

Expression Transformation

Mapping using Expressions

Filter Transformation

Mapping using Filter

 

Informatica –Workflow Manager

Workflow Introduction

Tasks

Workflow Tools

Connections

Defining Tasks

i.         Command Task

ii.       Email Task

iii.      Session Task

Setting properties of Session Task

Creating Workflow

Scheduling Workflow

Starting Workflow

Monitoring Workflow

 

Informatica Designer

Stored Procedure Transformation

Creating Stored Procedures

Unconnected Stored Procedures

Using connected Stored Procedures

Aggregator Transformation

Update flags

 

Informatica Designer

Update Strategy

Type –I with Mapping

Type –II with Mapping

 

Informatica Designer

Update Strategy

Type –II with Mapping

 

      Informatica Demo Class

 

 

Business Objects

Back to Top  

 

Introduction to Business Objects

Business Objects

Business Objects Tools

Introduction to Designers

Connections –Types of Connections

What is a Universe?

Creating a Universe

Importing Tables

Aliases

Business Objects Designers

Joins

Defining Joins

Cardinality

Detecting Cardinality

Creating Classes

What are Objects?

Dimensions

Detail

Measure

LOVs

 

Business Objects –Designer

Conditions

Loops

Traps

Hierarchies

Integrity Check

Exporting/Importing Universe

 

Business Objects –Reports

Table Report (Simple list)

Setting Title

Formatting Title

Formatting Column Header

Formatting Cells

Column Break

Creating a duplicate Report

Creating a Blank Report

Renaming a Report

 

Business Objects –Reports

Cross-tab Report

Charts

Changing Chart Style

Grouping a Data

Filtering a Query

Refreshing a Report

Sending a document to a User

Publishing a Document

 

Business Objects –Reports

Personal Data Files as Data Provider

Free hand SQL as Data Provider

Visual Basic as Data Provider

Creating PDF Files

Creating HTML Files

 

Business Objects –Repository

Starting Supervisor

Creating Repository

Creating Groups

Creating Users

Setting Properties of Users

Setting Privileges to Users and Groups

Web Reporting

Info-view

Creating Reports

Publishing Reports

 

Cognos

 Back to Top

 

Introduction to Cognos

Cognos Tools

Architecture

Introduction to Impromptu Administrative

Defining Connections

What is a Catalog?

Types of Catalog

 

Impromptu Administrator

Creating a Catalog

Tables

Joins

Working with Folders

Creating Folders

Copying Contents

 

Impromptu Administrator

Working with Folders

Calculation

Condition

Prompts

Generating Reports

Query Job Overview

Creating Folders

Copying Contents

 

Impromptu Administrator

Report Layouts

Creating Cross –Table Reports

Creating Group List Report

Defining Calculations

Defining Summary Report

Condition Formats

Components of a Report

Custom Report

 

Impromptu Administrator

Custom Reports

Creating Templates

Drill Down Reports

Sub Reports

Creating PDF/HTML/QD/Snapshot

Hotfiles

 

Introduction to power play Transformer

Multi Dimensional Model

Creating Dimensions and Levels

Creating Measures / Types of Measures

Defining Calculated Source Columns

 

Power Play Transformer

Generating Categories

Creating Power Cubes

Creating Cube group

Generating Reports from Power Cubes