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

Premium Poster


since February 2006

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

Joined: 29 May 2003
Posts: 5227
Location: Dallas, TX
Points: 35013

Post Posted: Mon Jan 06, 2014 2:41 pm Reply with quote    Back to top    

Why are most of the MDM topics about something other than MDM? Anyway, I think most the tables in MDM are designed poorly and cause performance issues. I wanted to discuss this for a while now. M ...

_________________
Mamu Kim

Last edited by kduke on Mon Jan 06, 2014 3:23 pm; edited 1 time in total
kduke

Premium Poster


since February 2006

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

Joined: 29 May 2003
Posts: 5227
Location: Dallas, TX
Points: 35013

Post Posted: Mon Jan 06, 2014 2:52 pm Reply with quote    Back to top    

I am breaking this up into chunks because it times out on me otherwise. So next lets look at the REL tables as fact tables. Lets look at what we have to do to display the current Org chart when u ...

_________________
Mamu Kim
Rate this response:  
Not yet rated
kduke

Premium Poster


since February 2006

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

Joined: 29 May 2003
Posts: 5227
Location: Dallas, TX
Points: 35013

Post Posted: Mon Jan 06, 2014 3:11 pm Reply with quote    Back to top    

Why is this wrong or poorly designed? If all your attributes are similar or work together then eliminate things like type 2 dimensions or snowflaking. When your data structures are clean and all the a ...

_________________
Mamu Kim
Rate this response:  
Not yet rated
kduke

Premium Poster


since February 2006

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

Joined: 29 May 2003
Posts: 5227
Location: Dallas, TX
Points: 35013

Post Posted: Mon Jan 06, 2014 3:23 pm Reply with quote    Back to top    

Simple fix. Move END_DATE to REL tables. I will rename these to FACT tables so you can see how easily this works. Find the top: Code: Select    P.LAST_NAME,     ...

_________________
Mamu Kim
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