Where we use surrogate key explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are the basic needs to join two sources in a source qualifier?
How to use the tool Ontobulider
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
Why we use repository connectivity?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
Explain what are the various reporting tools in the market?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What is factless fact schema?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
How do we design a universe?