How to drill through from a powerplay cube to reportnet?
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 why denormalization is promoted in universe designing?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is static and local variable?
Explain what is difference between query studio and report studio?
What is the goal of optimizer?
Difference between PowerPlay transformer and power play reports?
List down some of the real time data-warehousing tools?
What is the difference between connected and unconnected stored procedures?
What are diagrams?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
How can we load the time dimension?
How can we determine what records to extract?
What is the difference between power center and power mart?