Theare is a Database In analysis services,How we will
specify the fact table.(i.e whether we will create the
measure objects for the fact tbl.) or it will reside insde
the database.
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to know the time taken for particular report execution?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Why facts table is useful in representing the data?
What is surrogate key? Explain with examples.
After the complete generation of a report who will test the report and who will analyze it?
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?
When should you use a STAR and when a SNOW-FLAKE schema?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
What is conformed fact?
What are the types of SCD?
What needs to be done while starting the database?