Explain difference between e-r modeling and dimentional modeling?
DWH architecture?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
What is Data purging?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Explain how are the dimension tables designed?
Explain grouped cross tab?
what is table partitioning? How it is useful to warehouse database?
Explain the structure of cold fusion?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What are Aggregate tables?
Explain conformed fact?