calltomadhu

 Profile Answers by calltomadhu 

• Sep 23rd, 2006

 

hi

becuase time dimension is rapidly changing dimenction. if you use mapping it is very big stuff and that to be it very big problem in performence wise.

thanks

madhu

mahesh

• Aug 26th, 2007

 

How can time dimension be a rapidly chnging dimensions. Time dimension is one table where you load date and time related information so that the key can be used in facts. this way you dont have to use entire date in the fact and can rather use the time key. there are a number of advantages in performance and simplicity of design with this strategy.

You use a script to laod time dimension becuase you load it one time. as i said earlier all it contains are dates starting from one point of time say... 01/01/1800 to some date in future say 01/01/3001