What is XMLA ?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Explain swot analysis?
Fact table is in normalized or de-normalized form?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
what is Materialized Views?
Explain a relation schema and a relation?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is the function of etl when used in data warehousing?
I know of using applysimple, but there are other ways too?
What are the steps to build the datawarehouse?
What needs to be done when the database is shutdown?