Answer Posted / srinivas
Snow flake schema is a database. it is having centrally
located fact table. and the fact table is surronded by
dimension tables the dimension tables are exploded.
it is a normalized schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data analytics in simple terms?
What is hybrid slowly changing dimension?
What are data validation strategies for data mart validation after loading process?
Explain what is metadata reporter?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
ware house management system is used?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Tell me what is degree of a relation?
Why we use repository connectivity?
How do you create surrogate key using ab initio?
What is data analysis? Where it will be used?
Explain me what are data marts?
what are the other factors of the database on which the loading performance depend?
List down some of the real time data-warehousing tools?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?