Data Warehousing

Course Content

Database Run through

Data definition language, Data Manipulation Language,, DTL statements
Writing fundamental SQL SELECT Statement
Get rid of Duplicate Rows
Restricting in addition to Sorting Data
Joins: inner join, outer join, self join, natural join
Indexes

Introduction to Data Warehousing

Differences flanked by Transactional in addition to Warehoused Data
Data Warehouse structural design
Logical and Physical plan
Difference flanked by Data Warehouse & Data Mart
Source Data, Staging Data & Target Data


Database Design in addition to Modeling

Conversion of Logical Model into corporal representation
Application of Business system
Constraints, Triggers, Domains, Backend Programs, etc.
Dimensional Model for Data storehouse
Defining Dimensions and actions
Defining Levers as well as Hierarchies
Granularity of information
Introducing Star Flake plan
Introducing Snow Flake diagram
Dimension Table and Fact table

Business Objects XI R2

Administrating the Users furthermore Groups
Administrating the Servers
Access rights
Designing the world
Central Configuration Manager
Accessing the Info view


OLAP & Presentation using Business Objects

Creating in addition to Maintaining Universe
Formatting information
Slicing & Dicing Reports
DrillDown, Drillup Reports

INFORMATICA

• Data Staging Area
• Facts & Dimensions
• Data warehouse and Latency
• Data Integration
Repository Topics
• Repository Server and agent
• Repository maintenance
• Repository Server Administration Console
• Security, Repository, privileges and folder permissions
• Objects sharing, searching, and locking
• Metadata extensions