Populating a time dimension

mleroux · Post by **mleroux** » Thu Jul 15, 2004 5:31 am

I have a time dimension that simply needs sequential date values in a YYYY-MM-DD format.

How can I use a DataStage job to populate a time dimension? (I am not interested in PL/SQL scripts, etc. I know how to do it with those.)

There must be no datasource. The job must generate the values and insert them into the table in one run.

Thanks for your help!

chulett · Post by **chulett** » Thu Jul 15, 2004 5:55 am

Take a look here and see if that helps.