Data Warehousing Training

Data Warehousing Online Training

Introduction to 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 Ute Cycle

Data warehousing Architecture

  • Source
  • Integration Layer
  • Staging Area
  • Targets
  • Analysis & Reporting
  • HPQS

Data Modelling

  • Introduction
  • Different Phases of Modeling

Multi Dimensional Modelling

  • What are Facts?
  • Multi Dimensional Model
  • Hierarchies
  • OLAP
  • MOLAP
  • ROLAP
  • HOLAP
  • Cubes and its Functions
  • Star Schema
  • Fact Table
  • Dimensional Tables
  • Snow flake Schema
  • Fact less Fact Table
  • Confirmed Dimensions

Data Modelling Tools

  • Forward Engineering
  • Reverse Engineering
  • Update Model, Alter database
  • Complete compare
  • 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 & Unconnected)
  • Union Transformation
  • XMl Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III
  • Mappings

Informatica -workflow Manager

  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connections
  • Defining tasks
  • (i) Command Task
  • (ii) Email Task
  • ii) Session Task
  • (iv) Link Conditions
  • (v) Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow

Informatica Advanced Features

  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading
  • Mapping Parameters
  • Session parameters
  • Link Conditions
  • Meta Data Backup & Restore
  • Copying Repository
  • Deleting Repository
  • Sending Notification Messages

Business Objects 6.5 with BO-XI

  • Desktop Products
  • Designer Module
  • Supervisor Module
  • Business Objects
  • Introduction to Designing Universes
  • Reporting Requirements
  • The Designer Module
  • Populating the Structure with Tables Joins
  • Creating and testing Classes & Objects
  • Creating and testing Measure Objects
  • Resolving loops In a Universe

Business objects with webintelligence 6.5

  • Introduction to Webintelligence 6.5
  • Getting Started with Infoview
  • Viewing Documents in Infoview
  • Creating New Documents with Queries
  • Restriction Data Returned by a Query
  • Displaying Information in different Ways
  • Enhancing Report Presentation
  • Formatting Reports
  • Creating Formulae and Variables
  • Analyzing Data at a Deeper Level
  • Sharing Documents
  • Architecture
  • Designer
  • CMS
  • Desktop Intelligence
  • Web Intelligence

Cognos ReportNet with Cognso 8

  • Architecture
  • Framework Manager
  • Metadata Modelling
  • Package Development
  • Package Import & Export
  • Query Studio
  • Report Studio -Basics
  • Report Studio -Advanced

DataStage 7.X

  • 1.DataStage Administrator
  • Server Properties
  • DataStage Project Administration
  • Adding Projects
  • Deleting Projects
  • Cleaning up Project files
  • NLS Configuration
  • Project Export Option
  • Project Import Option

DataStage Director

  • Introduction to DataStage Director
  • DataStage Director Window
  • Jobs Status View
  • DataStage Director Options
  • Limits Page
  • View Page
  • Priority Page
  • Running DataStage Jobs
  • Validating a Job
  • Running a Job
  • Stopping a Job
  • Resetting a Job
  • Job Scheduling
  • Deleting a Job

Job Batches

  • Introduction to Job Batch
  • Creating a Job Batch
  • Running a Job Batch
  • Scheduling a Job Batch
  • Unscheduling a Job Batch
  • Monitoring Jobs
  • The Monitor Window
  • Showing Unks
  • Showing (])U Usage
  • Stage Status Window

DataStage Designer

  • Importing Table Definitions
  • Importing Flat Ale Definitions
  • Designing Server Jobs
  • Aggregator Stage
  • Transformation Stage
  • Annotations
  • Annotations Descriptions
  • Shared Containers
  • Local Containers
  • Reject Rows
  • Implementing RouterStage
  • Data Elements
  • Routines
  • Developing Custom Routines
  • Job Sequencer
  • Implementing Simple & Complex Jobs

DataStage Manager

  • Introduction to DataStage Manager
  • Importing Table Definitions
  • Importing Flat File Definition
  • Managing the Meta Data Environment

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message