mobileNavlogo
headerlogo

Blog

Schemas and its types in Cognos

21 September, 2018

Related Blogs

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

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .