Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
What are the types of Schemas we have in data warehouse and what are the difference between them?
Home
Technology
What are the types of Schemas we have in data...
asked
Mar 29, 2021
in
Technology
by
JackTerrance
What are the types of Schemas we have in data warehouse and what are the difference between them?
interview-question-answer
technology-questions-answers
1
Answer
0
votes
answered
Mar 29, 2021
by
JackTerrance
There are three different data models that exist.
Star schema
Here, 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.
Snowflake schema
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.
Fact constellations
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
Q: What are the 3 main differences between OLTP and Data warehouse in SAP BODS?
What are the 3 main differences between OLTP and Data warehouse in SAP BODS?...
asked
Nov 30, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: Can we run business warehouse without SAP R/3 implementation?
Can we run business warehouse without SAP R/3 implementation?...
asked
Jan 4, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What are the various types of schemas supported by Talend?
What are the various types of schemas supported by Talend?...
asked
Mar 18, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What are common types of Schema’s used in websites?
What are common types of Schema’s used in websites?...
asked
Mar 5, 2021
in
Technology
by
Editorial Staff
interview-question-answer
technology-questions-answers
0
votes
Q: suppose that you are the data analysts on the project team building a data warehouse foe an insuranc
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: The two windings of a transformer have an inductor of 2 H each. If mutual inductor between them is also 2 H, then which of the following is correct?
The two windings of a transformer have an inductor of 2 H each. If mutual inductor between them is also 2 H, ... for GATE EC Exam, Network Theory MCQ (Multiple Choice Questions)...
asked
Oct 20, 2021
in
Education
by
JackTerrance
network-theory-questions-and-answers
network-theory-questions-pdf
network-theory-question-bank
network-theory-gate-questions-and-answers-pdf
mcq-on-network-theory-pdf
gate-network-theory-questions-and-solutions
network-theory-mcq-test
0
votes
Q: What are the types of reports that we have in Salesforce?
What are the types of reports that we have in Salesforce?...
asked
Nov 12, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: What kind of data warehouse application is suitable for Hive?
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
bigdata
hive
0
votes
Q: Statement 1: Row-oriented storage is optimal for transaction processing applications. Statement 2: Column-oriented storage is efficient for data-warehouse workloads.
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
computer-science-interview-questions
computer-science-questions
0
votes
Q: What are the different data types that a standard field record name can have?
What are the different data types that a standard field record name can have?...
asked
Nov 11, 2020
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This is
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
Q: Describe the concept of “Business Content” in SAP Business Information Warehouse? [_private/tble_firefox.htm]
Describe the concept of “Business Content” in SAP Business Information Warehouse? [_private/tble_firefox.htm]...
asked
Jan 5, 2021
in
Technology
by
JackTerrance
interview-question-answer
technology-questions-answers
0
votes
Q: Difference between Pig and Hive? Why have both?
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
hadoop
hive
apache-pig
0
votes
Q: ___________ helps us to find relationship between different elements of the problem which we have scoped.
Select the correct answer from above options...
asked
Nov 12, 2021
in
Education
by
JackTerrance
science-interview-questions
science-interview-questions-answers
science-multiple-choice-questions
science-mcq-with-answers
science-mcq
science-questions
0
votes
Q: Suppose you have some subset of codes with you while working with the SVN and you need to move them from one SVN repo simply to another along with their history, how this can be done?
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
interview-question-answer
technology-questions-answers
...