What is called dimensional modelling?

Question Posted / vikram kapoor

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

More Data Warehouse General Interview Questions

Which columns go to the fact table and which columns go the dimension table?

Explain difference between snow flake and star schema.

What is difference between model & package?

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

What is data type of the surrogate key?

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

capital of tamilnadu

What are situations where snowflake schema is better than star schema when the opposite is true?

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

What is fact less fact table? Where you have used it in your project?

Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

For more Data Warehouse General Interview Questions Click Here