Sakthi

• Aug 4th, 2005

 

Time dimension is one of important in Datawarehouse. Whenever u genetated the report , that time u access all data from thro time dimension. 
 
eg. employee time dimension 
 
Fields : Date key, full date, day of wek, day , month,quarter,fiscal year

prasad nallapati

• Aug 25th, 2005

 

In a relational data model, for normalization purposes, year lookup, quarter lookup, month lookup, and week lookups are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called TIME DIMENSION for performance and slicing data. 
 
This dimensions helps to find the sales done on date, weekly, monthly and yearly basis. We can have a trend analysis by comparing this year sales with the previous year or this week sales with the previous week. 
 

Lenin

• Nov 1st, 2005

 

A TIME DIMENSION is a table that contains the detail information of the time at which a particular 'transaction' or 'sale' (event) has taken place. 

The TIME DIMENSION has the details of

DAY, WEEK, MONTH, QUARTER, YEAR