DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
datastage
Participant

Group memberships:
Premium Members, DSXchange Team, Heartland Usergroup

Joined: 23 Oct 2002
Posts: 229
Location: Omaha
Points: 1566

Post Posted: Fri Feb 27, 2004 1:37 pm Reply with quote    Back to top    

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
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54085
Location: Sydney, Australia
Points: 293335

Post Posted: Sat Feb 28, 2004 6:18 am Reply with quote    Back to top    

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

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
falsehate
Participant



Joined: 16 Mar 2004
Posts: 9

Points: 150

Post Posted: Tue Mar 16, 2004 12:11 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours