DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
kripakrish



Group memberships:
Premium Members

Joined: 18 Sep 2006
Posts: 15

Points: 107

Post Posted: Fri Apr 20, 2007 12:29 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Server
OS: Unix
I was searching about SCD types and the forum has lots of dicsussion about scd's. I came across different dimension types like conformed, degenrative (to name a few) . Can some body please explain the various dimension types.
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: Fri Apr 20, 2007 3:22 pm Reply with quote    Back to top    

Ken Bland has given some of more detailed answers on this. Do a search.

_________________
Mamu Kim
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54070
Location: Sydney, Australia
Points: 293276

Post Posted: Fri Apr 20, 2007 3:24 pm Reply with quote    Back to top    

A "regular" dimension is one - it doesn't really have a name - that is a parent table to a fact table. That is, the fact table has a foreign key that is resolved in the dimension table. Conforme ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
kripakrish



Group memberships:
Premium Members

Joined: 18 Sep 2006
Posts: 15

Points: 107

Post Posted: Fri Apr 20, 2007 5:03 pm Reply with quote    Back to top    

Thnks a lot.Appreciate your quick responses.
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