RE: 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)?
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
