in Technology by

What are the types of Schemas we have in data warehouse and what are the difference between them?

1 Answer

0 votes
by

There are three different data models that exist.

  1. Star schemaStar-schema-informatica-interview-questionsHere, the Sales fact table is a fact table and the surrogate keys of each dimension table are referred here through foreign keys. Example: time key, item key, branch key, location key. The fact table is surrounded by the dimension tables such as Branch, Location, Time and item. In the fact table there are dimension keys such as time_key, item_key, branch_key and location_keys and measures are untis_sold, dollars sold and average sales.Usually, fact table consists of more rows compared to dimensions because it contains all the primary keys of the dimension along with its own measures.
  2. Snowflake schema
    Snowflake-schema-informatica-interview-questions
    In snowflake, the fact table is surrounded by dimension tables and the dimension tables are also normalized to form the hierarchy. So in this example, the dimension tables such as location, item are normalized further into smaller dimensions forming a hierarchy.
  3. Fact constellations
    Fact-constellations-informatica-interview-questions
    In fact constellation, there are many fact tables sharing the same dimension tables. This examples illustrates a fact constellation in which the fact tables sales and shipping are sharing the dimension tables time, branch, item.

Related questions

0 votes
    What are the 3 main differences between OLTP and Data warehouse in SAP BODS?...
asked Nov 30, 2020 in Technology by JackTerrance
0 votes
    Can we run business warehouse without SAP R/3 implementation?...
asked Jan 4, 2021 in Technology by JackTerrance
0 votes
    What are the various types of schemas supported by Talend?...
asked Mar 18, 2021 in Technology by JackTerrance
0 votes
    What are common types of Schema’s used in websites?...
asked Mar 5, 2021 in Technology by Editorial Staff
0 votes
    suppose that you are the data analysts on the project team building a data warehouse foe an insurance company. ... data warehouse? Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
    What are the types of reports that we have in Salesforce?...
asked Nov 12, 2020 in Technology by JackTerrance
0 votes
    Can anyone tell me what kind of data warehouse application is suitable for Hive? Select the correct answer from above options...
asked Jan 8, 2022 in Education by JackTerrance
0 votes
    Statement 1: Row-oriented storage is optimal for transaction processing applications. Statement 2: Column-oriented ... correct? Select the correct answer from above options...
asked Nov 29, 2021 in Education by JackTerrance
0 votes
    What are the different data types that a standard field record name can have?...
asked Nov 11, 2020 in Technology by JackTerrance
0 votes
    Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing ... Management topic in portion Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Describe the concept of “Business Content” in SAP Business Information Warehouse? [_private/tble_firefox.htm]...
asked Jan 5, 2021 in Technology by JackTerrance
0 votes
    I have just started with Hadoop. Using Cloudera's Hadoop VM, I worked with Hive, Pig and Hadoop. As I worked, ... we need them both? Select the correct answer from above options...
asked Jan 20, 2022 in Education by JackTerrance
0 votes
    Suppose you have some subset of codes with you while working with the SVN and you need to move them from one SVN repo ... to another along with their history, how this can be done?...
asked Feb 18, 2021 in Technology by JackTerrance
...