Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Dimension Load

Prerna VijOct 4 2012 — edited Oct 4 2012
Hi,

I need to populate my Date dimension with generic values.
The structure of the Dimension Table is :-
Name Null Type
------------------------------ -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date_Key NUMBER
Date DATE
Month NUMBER
Quarter NUMBER
Year NUMBER

In the Date_Key field, I want to populate a meaningful key value like not a surrogate key.

Please provide pointers as to how i should move forward with this.

I tried looking for a stored procedure to populate the table but could not find one.


Thanks,
Prerna
This post has been answered by Sutirtha Roy on Oct 4 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2012
Added on Oct 4 2012
#business-intelligence-applications, #data-integrator, #system-management-and-integration
5 comments
3,518 views