Explain is fact table?
No Answer is Posted For this Question
Be the First to Post Answer
What is surrogate key? Where we use it explain with example?
What are different deliverables according to phases?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What are the reasons to use a chameleon method in data warehousing?
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.
Explain the different types of data warehousing?
Which columns go to the fact table and which columns go the dimension table?
DWH architecture?
What is Discover and Execute in XMLA?
What is meant by metadata in context of a data warehouse?
Explain bus schema?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?