robber at 15h41
11
Feb
2011
fast changing dimension
I'm debating how to model a teacher work force where most often a teacher works for one school authority. The issue is where a teacher works for multiple school authorities. A substitute teacher for example could work for a different school authority every day of the week which has me worried about using an SCD approach.
Ideally in the teacher dimension I want a hierarchy where every teacher belongs to a school authority, any recommendations?
I'm debating how to model a teacher work force where most often a teacher works for one school authority. The issue is where a teacher works for multiple school authorities. A substitute teacher for example could work for a different school authority every day of the week which has me worried about using an SCD approach.
Ideally in the teacher dimension I want a hierarchy where every teacher belongs to a school authority, any recommendations?
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
Hi Everyone,
I have a list of more than 300 attributes, which are actually part of the fact table
.(basically ..these values changes for each transaction level record in fact but belongs to a single dimension).
that lot contains more than a 100 date
Hello, I have a slowly changing dimension table with 105 attributes. About 85% of the attributes are type 1 and the remaining 15% are type 2. I have 4 fields that are type 2 that change a lot more frequently than the rest of the type 2 fields. On a
I am trying to find a best example / scenario where a type 3 scd would make more sense than a type 2. In my understanding type 3 can easily be derived from type 2.
If anybody has used type 3 dimension instead of type 2, please let me know the scenario an
I'm new to data warehousing .. sorry if this is a basic question.
I have a type 2 slowly changing dimension already loaded and now I want to load a fact table. At least, I think it should be a fact table. A lot of the entities in the dimension table
Hello,
I have scenario where we are creating a Dimension Table and Fact Table from the same Source Table which contains
both descriptive and numeric data
I want to model the Dimension table as a Slowly changing Dimension Type 2 (create new
Forums from same category
LEGO Island Discussion, modding, news and more!
HmongThoobNtiajTeb. com/
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
Informations
11 Replies For the topic :
"fast changing dimension"
This topic has been viewed 1632 times.
Last message :
11/02/2011 at 15h41 by "robber"






