Date dimension in data warehouse

[harborboy76]

I am new to DataStage and would like to find out what other people are
using to populate some common dimensions like date or year dimension.

What are most common attributes and how to populate the table appropriately ?
Do you guys use stored procedure and database function to add dates ?

[ray.wurlod]

I typically use a server job (with a Transformer stage as a row generator) or a parallel job (with a Row Generator stage) to generate the dates and surrogate keys.

Attributes in a date dimension vary with different customers' requirements.
Typically they will include:

• date components (day, month, quarter and year numbers, weekday)
  
  range components (e.g. date of last day of month)
  
  intelligence components (e.g. weekday/weekend)
  
  calendar year and financial year components
  
  other (e.g. season)

[krishnuka123]

For date dimension, should write Procedure along with require attribute as per the business requirement. When you compile the job corresponding data will fetch form your database at run time.