What is dimensional modelling?
No Answer is Posted For this Question
Be the First to Post Answer
What are aggregate fact tables ? why they are needed? give an example
5.Explain ODS ?
What is surrogate key? Where we use it?
How can we do ETL process in SQL Server?
What is Molap and Rolap? What is Diff between Them?
What is perform recovery?
What is Grain & Granularity in Data Warehouse.
What is the function of surrogate key in data warehousing?
What is an OLAP (On-line Analytical processing) system?
What are the differences between datamart vs. Reporting cube?
Explain how many ways you create ports?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?