Explain how are the dimension tables designed?

Question Posted / rakesh

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

Explain hybrid slowly changing dimension?

if we increase the number of dimensions will the rows in fact table increase or decrease??

How to generate the cubes in framework manager?

What is the difference between an ODS and a W/H?

What is execution plan?

How can you define a transformation? What are different types of transformations in Informatica?

How can we run the graph? How can we schedule the graph in unix?

What is the difference between a primary and secondary actor in use case modeling?

Explain which are the olap tools available that are supported by oracle?

What is subject area?

Explain difference between snow flake and star schema.

For more Data Warehouse General Interview Questions Click Here