Since RazzaDS is intended to manage large complex dimensions with different hierarchical view across the enterprise such as accounts or product line dimensions, I was curious if there was any worth in trying to also manage a date dimension in a central place, possibly with just the goal of making the ETL updates of date dimensions easier.
Does it make sense to try this or has anyone tried this with success or failure?
RazzaDS and Date/Time dimensions [Razza]
Moderators: chulett, rschirm, falsehate
RazzaDS and Date/Time dimensions [Razza]
Last edited by datastage on Sun Mar 14, 2004 12:06 pm, edited 1 time in total.
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.
"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.
"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Doesn't really make sense. Typically you populate your date dimension well into the future. About the only thing that would ever change would be the holiday information - unless a Pope gets the notion to fiddle with the calendar again! So the date dimension should require little if any updating. IMHO.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
This is very often done to accomodate the automated launch of a cube with a one stop shopping approach to dimension aquisition via a Razza Dimension Server Book, which is a group of exports. Actually managing the time dimension in RazzaDS doesn't actually add a lot of value beyond the ability to ship it with the rest of the dimensionality in the cube and possibly control security configuration metadata.