How to create a TIME DIMENSION in the Target Database(Oracle)?

There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?

hai_malli
Profile Answers by hai_malli Questions by hai_malli
Mar 11th, 2006
5
2377

Questions by hai_malli

Informatica

Answer

Showing Answers 1 - 5 of 5 Answers

Jagadeesh

Mar 31st, 2006

Hi
I already explained in another mail....
U need to use procedure
Further queris write to me
From
Jagadeesh

Motilal

Jun 30th, 2006

Hi Jagadeesh,
Can you please mail me with the answer of calling the stored procedure for time dimension.
And can have the procedure for time dimension in Oracle..?

arun.menon
Profile Answers by arun.menon

Oct 24th, 2008

Time and Date dimensions are static dimension. Those are one time activity to populate these tables. It is just the naming convetion used across the projects. If you observe these tables, it will have details about date and lowest granularity will be day of a year. I dont think we keep hourly info. So you can directly execute the pl/sql program once and verify your date dimension table is loaded correctly.

Trying coding some customized script which load the data as per fixed number of levels such as Year, Quarter, Month and Day

Cheers
Arun