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?
_________________
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.
"Strange things are afoot in the reject links" - from
Bill & Ted's DataStage Adventure
Last edited by datastage on Sun Mar 14, 2004 12:06 pm; edited 1 time in total
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 noti ...
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.
Add To Favorites View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum