You should be able to explain how they can compile facts and figures for preliminary analysis, derive relevant facts and information from the study of this data.
Can any one explain the Hierarchies level Data warehousing.
Can any one explain about Core Dimension, Balanced Dimension, and Dirty Dimension?
How much data hold in one universe.
What is Core Dimension?
After we create a SCD table, can we use that particular Dimension as a dimension table for Star Schema?
What is the difference between Snowflake and Star Schema? What are situations where Snowflake Schema is better than Star Schema when the opposite is true?
What is the difference between star and snowflake schemas?
Can a dimension table contain numeric values?
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.
How do you create Surrogate Key using Ab Initio?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
