• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Schemas and its types in Cognos

Schemas and its types :

Schema:

A schema is nothing but a collection of objects

  • Designing a dWH is nothing but designing the schema
  • A data ware house tables are contain dimensional tables and fact tables
  • Database models follows dimensional modeling to design dWH schema
  • Dimensional modeling is a process of creating dimensional tables and fact tables with proper relation

Types of schemas:

  1. Star schema
  2. Snow flake schema
  3. Galaxy schema (or)integrated schema (or) constellation schema

STAR SCHEMA:

A star schema design is a data base design where the centrally located table is called fact table with surrounded by number of dimensional tables

  • Since the database design looks like star, it is called star schema

Format of star schema:

Screenshot_11

Dimensional tables:

  • A dimensional table contains detail information (or) descriptive information
  • Dimensions are used to describe the facts.

Fact table: 

  • A fact table contains all the key columns (PK, FK) and measures of the particular business organizations.
  • Measures are also called as facts (or) KPI’s (key performance indications)
  • fact should be a numeric but every numeric near not be a fact.

Sales schema

Screenshot_12

Learn the core features of Cognos and become master with our expertise tutorials.

Snow flake schema:

Screenshot_13

Difference between the schema and snow flake schema:

Star schema Snow flake schema
It is de normalizedRetrieval up data is faster

redundancy is there

 it is normalizedRetrieval up data is slower due to more number of icons

redundancy can be reduced

Integrated schema:

Screenshot_14

For indepth understanding Cognos Training click on

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Schemas and its types in Cognos"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.