DATAWAREHOUSING

DATAWAREHOUSING

COURSE CONTENTS

Datawarehousing Concepts
 What is Data warehouse?
 Characteristics of Data warehouse.
 What is Data warehousing?
 Principles of Data warehouse.
 Benefits of DWH.
 What is Online transactional systems (OLTP)?
 Difference between OLTP and DWH.
 Architecture of DWH.
 HPQS.
 Approaches of Data warehousing.
 Normalization and Denormalization.
 DWH Lifecycle:
 Data Modeling
 Dimension table
 Fact Table
 Aggregate table
 Schemas
 Types Of Fact Tables:
 Types Of Facts:
 Types of Dimensions
 ODS
 Cube
 Hierarchies
 Slowly changing Dimension Concepts
 OLAP’s:

Erwin
 Getting Started
 Erwin Workplace
 Model Explorer
 Dockable Toolbars
 Model Types
 Stored Display Tabs
 Basic Data Model Objects
 Identifying
 Non-identifying
 Display Levels
 Subject Area
 Indexes

INFORMATICA

 Introduction to Informatica
 Products of Informatica
 Difference between Power mart and Power center
 Installation of Informatica
 Configuration
 Informatica Architecture
 Informatica Client Tools
 Designer (Components)
 Workflow Manager (Components)
 Workflow Monitor
 Repository Manager
 Repository Server Admin Console
 Informatica Server Tools
 Repository Server
 Server Architecture
 Transformations
(Source Qualifier, Filter, Expression , Aggregator,
Joiner, Router, Rank, Sorter, Sequence Generator
Union, XMLSQ, Lookup {Connected/Unconnected}
 Stored Procedure (Connected/Unconnected)
 Update Strategy,Transaction Control
 Normalizer, Application Source Qualifier
 Application multi-group Source Qualifier
 Custom, Mapplet Input, Mapplet Output
 Midstream XML Generator, Midstream XML Parser
 Concepts: SQL Override, Working with files
 File Repository Concept, Constrained Based Loading
 Parameters (Mapping, Session)
 Mapping Variables, Incremental Aggregator
 Scheduling, Debugging
 Slowly Changing Dimension

BUSINESS OBJECTS

 BO Reporting Tool
• Introduction
• The Query Panel
• Reporting Option:
(Simple, Turning Tables to chart, Breaks,
Sections , Ranking , Filter, Alerters
Crosstabs, Grouping, Slice – and – Dice,Drill
Master/Detail Reports)
• Formatting Cells/Tables
• The Structure View
• Insertion of Rows or Columns
• Exporting Data
• Data Providers
 Introduction to BO Designer
 Universe and Object Creation
• Initiating Universe Design
• The Parameters
• Saving a Universe
• Configuring Saving Routines
• Adding Tables
• Dimension /Detail Relationship
• Classes and Objects Window
• Creating a Dimension Object
• Other Object Properties
• Creating Detail Object
• Testing Objects
• What do joins achieve in SQL
• An Equi Join
• An Outer join
• A Theta join
• What is a Measure Object?
• Semantic Dynamism
• Creating a Measure Object
 Creating Hierarchy
• Applying Restriction
• The WHERE Clause in SQL
• Influencing the WHERE Clause
• Free Floating Condition Objects
• WHERE Clauses on Measure Objects
• Additional join Information: Lookups
• Flexible Restrictions: @Prompt

 Resolving Loops and SQL Problems
• What is a Loop?
• How to deal with Loops
• What is an Alias?
• Using Automatic Alias Detection
• Defining Objects from Aliases
• Database Structure: Context Situations
• Context situations: Errors in SQL
• How BusinessObjects detects Contexts
• The 'Incompatible’ Query: Multi Path SQL
 Supervisor
• Introduction
• Installing the Repository
• Basic Procedure
• Starting Supervisor
• Creating General supervisor
• Creating group profiles
• Creating User groups
• Managing Users and Groups
• Managing resources
• Assigning Resources to users
• Importing and Exporting Users and Groups

Business Objects with Web Intelligence
 Introduction to Webintelligence 6
 Getting started with Infoview
 Viewing Documents in Infoview
 Creating New Documents with queries
 Restricting Data returned by a Query
 Displaying information in different ways
 Enhancing report presentation
 Formatting reports
 Creating Formulae and Variables

COGNOS

 Cognos Impromptu
• Creation of Catalogs
• Generating reports
 Power play – Window
• Architecture
• Report features
• Explorer
• Reports
• Local and remote
• Cubes
• Different types of Reports
• Business – mix Reports
• Top-10 (Rank reports)
• Variance
• Exception
• Quarter and Revenue
• Exploring Dimension folder
• Drill Down Dimension folder
• Filter Information
• Performance Indicator
• Slice and Disc
• Categories
• Swapping reports
 Transformer
• Power play Transformer Concepts
• Building Model
• Creating of power cubes
• Model and power cube maintains

Cognos Reportnet

 Cognos Reportnet an Architecture
• Various components
• Application server
• Reportnet server
• Dispatcher
• Content store
 Cognos connection
• Data source creation
• Server administration
• Scheduling
 Report studio
• Creation of simple report , cross tab report, complex reports
• Drill through report
• Prompts
• Conditional formatting
• Multilingual reports
 Query studio
• Creation of ad-hoc Reports
 Frame work manager
• Data modeling
• About query subject
• Name space
• Importing data source
• Physical layer
• Business layer
• Presentation layer
• Creation of star schema layer
• Package creation & Package publishing

contact : enq@trinityinfosolutions.net 9019539480

Trinity Infosolutions,No.2A, Robby Arcade(Second Floor), Above Cofee day, No.537,CMH Road,Bangalore-38 , ph : 30580014 / 11 /12 /13

Btm center : no.7, vijaya bank colony, (above Anand laboratory), 100 feet ring road,BTM II stage, Bangalore 76 ph :32476165 www.trinityinfosoultions.net