Introduction
- 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
- Star schema
- Snowflake schema
- Types Of Fact Tables:
- Cumulative
- Snapshot
- Fact less Fact
Types Of Facts:
- Additive
- Semi Additive
- Non Additive
- Confirmed Dimension
- Confirmed Fact
- Degenerated Dimension
- Casual Dimension
- ODS
- Cube
- Hierarchies
- Slowly changing Dimension Concepts
- OLAP’s
- Erwin
Getting Started
- Erwin Workplace
- Model Explorer
- Dockable Toolbars
- 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
- Configuring Informatica
- Configuring Informatica Repository Server
- Creating & Configuring Repository
- Configuration Informatica Server
- Configuration Temp Server(Workflow Manager)
- Informatica Architecture
- Informatica Client Tools
- Designer (Components)
- Source Analyzer
- Workflow Manager (Components)
- Workflow Monitor
- Repository Manager
- Repository Server Admin Console
- Informatica Server Tools
- Repository Server
- Server Transformations
- Source Qualifier
- Filter
- Expression
- Aggregator
- Joiner
- Router
- Rank
- Sorter
- Sequence Generator
- Union
- Xml Source Qualifier
- 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 (Sources, Target)
- File Repository Concept
- Constrained Based Loading
- Parameters
- Mapping Parameters Mapping Variables
- Session Parameters
- Incremental Aggregator
- Application Source Qualifier
- Debugging
- Slowly Changing Dimension
- BUSINESS OBJECTS
|
BO Reporting Tool
- The Query Panel
- Turning Tables to chart
- Formatting Cells/Tables
- The Structure View
- Insertion of Rows or Columns
- Breaks
- Sections
- Ranking
- Filter
- Alerters
- Crosstabs
- Grouping
- Slice – and - Dice
- Drill
- Exporting Data
- Data Providers
- Master/Detail Reports
- Introduction to BO Designer
- Simple Universe and Object Creation
- Creating Hierarchy
- Resolving Loops and SQL Problems
- Supervisor
BUSINESS OBJECTS
- Introduction to Webintelligence
- 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
- Power play Window
- Transformer
- Cognos Reportnet
- Cognos Reportnet an Architecture
- Cognos connection
- Report studio
- Query studio
- Frame work manager
|
