Answer Posted / bhaskar.nagi
A Data Warehouse is a type of Relational Data Base,
Specially designed for Query and Analytical processing
rather than for transactional processing.
A DWH is a
Time Variant
Non-Volatile
Subject Oriented
Integrated Data Base.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the other factors of the database on which the loading performance depend?
Explain what is batch and describe about types of batches?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Explain er diagram?
What is the difference between agglomerative and divisive hierarchical clustering?
What are the various file formats involved in reportnet?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain a relation schema and a relation?
Explain a mapping, session, worklet, workflow, mapplet?
What are Non-additive facts?
Explain why should you put your data warehouse on a different system than your oltp system?
What is the difference between junk dimension and degenerated dimension?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is prompt types of prompts?use of prompts syntax of prompt?