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.
Can a dimension table contain numeric values?
What is the difference between Datawarehouse and OLAP?
Where the cache files stored?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is multi-dimensional analysis?
How can we import and export using BCP utility?
What are vaious etl tools in the market?
What is the difference between view filter and report filter?
What are the different types of data warehousing?
What is is a star schema?
What is Cognos script editor?
What is the difference between connected and unconnected stored procedures?