Transitive Dependency
radsampath at 00h52
04
Feb
2009
Transitive Dependency
There are many dimensional tables in our organzation has got transitive dependency in them and we are forced to adopt different SCD types like type 1 and type 2
I will explain my scenario with an example(see table below) ,the Item dimension has got many attributes but i picked up only those where we have issues.In the below table dept,category,acct_dept,brand are all denormalized from source system and made into Item.All type 1 Item related attrib
There are many dimensional tables in our organzation has got transitive dependency in them and we are forced to adopt different SCD types like type 1 and type 2
I will explain my scenario with an example(see table below) ,the Item dimension has got many attributes but i picked up only those where we have issues.In the below table dept,category,acct_dept,brand are all denormalized from source system and made into Item.All type 1 Item related attrib
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
LEGO Island Discussion, modding, news and more!
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Search
Informations
8 Replies For the topic :
"Transitive Dependency"
This topic has been viewed 3330 times.
Last message :
04/02/2009 at 00h52 by "radsampath"
