RazzaDS and Date/Time dimensions [Razza]

Infosphere Master Data Management theory and best practices

Moderators: chulett, rschirm, falsehate

Post Reply
datastage
Participant
Posts: 229
Joined: Wed Oct 23, 2002 10:10 am

RazzaDS and Date/Time dimensions [Razza]

Post by datastage »

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?
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
ray.wurlod
Participant
Posts: 54588
Joined: Wed Oct 23, 2002 10:52 pm

Post by ray.wurlod »

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.
falsehate
Participant
Posts: 9
Joined: Tue Mar 16, 2004 12:06 am

Post by falsehate »

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.
Post Reply