Current date/time is Tue Nov 24, 2009 8:33 am

Dimensional Modeling and Data Architecture

• Page 2 of 5 •

1, 2, 3, 4, 5

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Topics
Replies
Views
Last Posts

Measures as special dimension table

by Kraft
0 Replies
69 Views
Last Posts Kraft
Fri Oct 16, 2009 12:03 pm
Periodic snapshot: insert when not changed?

by jochem_van_grondelle
1 Replies
90 Views
Last Posts ngalemmo
Thu Oct 15, 2009 9:06 am
Storing binaries/images in DWH good idea?

by jochem_van_grondelle
1 Replies
45 Views
Last Posts ngalemmo
Thu Oct 15, 2009 8:49 am
Null values in facts, yes or no?

by jochem_van_grondelle
10 Replies
335 Views
Last Posts jochem_van_grondelle
Thu Oct 15, 2009 7:28 am
Modelling Product Dimension when incoming fact records have missing lowest level

by abachwani
0 Replies
60 Views
Last Posts abachwani
Wed Oct 14, 2009 4:09 pm
INDEXING IN WAREHOUSE AND BUSINESS INTELLIGENCE

by arun a
1 Replies
97 Views
Last Posts ngalemmo
Tue Oct 13, 2009 8:50 am
modelling Product dimension for Pizza outlet

by dkalyan
6 Replies
118 Views
Last Posts dkalyan
Mon Oct 12, 2009 4:23 pm
proof of concept

by henry
2 Replies
81 Views
Last Posts ngalemmo
Fri Oct 09, 2009 12:18 pm
Value Banding linked to a calculation

by robhale
1 Replies
71 Views
Last Posts ngalemmo
Thu Oct 08, 2009 8:27 am
Heterogeneous Product Schema

by mark.tan
3 Replies
108 Views
Last Posts ngalemmo
Tue Oct 06, 2009 9:47 pm
Dimension same size as Fact

by Type2
1 Replies
140 Views
Last Posts ngalemmo
Mon Oct 05, 2009 9:28 am
Customer Orders, with Multiple Demography details

by rajsundar
5 Replies
209 Views
Last Posts rajsundar
Thu Oct 01, 2009 2:42 pm
Dimensional model

by Aspirant
2 Replies
142 Views
Last Posts alex.caminals@clearpeaks.
Wed Sep 30, 2009 1:37 am
Staging > ODS > EDW

by user2000
3 Replies
287 Views
Last Posts ngalemmo
Tue Sep 29, 2009 12:15 am
Dimensional table design dilemma, Aditional column or Xref table

by kvkeee
2 Replies
149 Views
Last Posts beyeguru
Mon Sep 28, 2009 10:00 pm
1 or 2 Dimensions - Customer & Shipping Address

by tonytiger
2 Replies
258 Views
Last Posts tonytiger
Wed Sep 23, 2009 2:31 am
Get Subdimension (outrigger) count (built using Bridge Table)

by raghuk
3 Replies
222 Views
Last Posts ngalemmo
Fri Sep 18, 2009 11:25 am
Using a dimension in multiple fact tables with different grain and support SCD

by MichaelBruns
7 Replies
789 Views
Last Posts BoxesAndLines
Fri Sep 18, 2009 6:25 am
Modeling Student Academic Programs

by dianaantova
1 Replies
142 Views
Last Posts alex.caminals@clearpeaks.
Thu Sep 17, 2009 10:14 am
How do I connect fact tables for drill down

by jburkard
3 Replies
333 Views
Last Posts ngalemmo
Thu Sep 17, 2009 8:39 am
many to many relationships in dimensional modelling???

by vjak001
3 Replies
273 Views
Last Posts MJ
Thu Sep 17, 2009 1:57 am
Employee Strength using Periodic Snapshot

by mark.tan
2 Replies
220 Views
Last Posts mark.tan
Thu Sep 10, 2009 12:01 am
Advice on factless table use

by dcow
1 Replies
191 Views
Last Posts Colin Davies
Thu Sep 03, 2009 8:02 pm
Architecture questions : implement historical data view without SCD?

by Viim
3 Replies
277 Views
Last Posts BoxesAndLines
Tue Sep 01, 2009 6:15 am
Dimension with Surrogate key of other dimension

by user2000
2 Replies
226 Views
Last Posts patrick_lavallee
Fri Aug 28, 2009 9:43 am
Transaction Fact design

by lalith160
5 Replies
433 Views
Last Posts ngalemmo
Fri Aug 28, 2009 9:27 am
Large number of snowflake code tables per dimension

by dennisf
7 Replies
305 Views
Last Posts ngalemmo
Fri Aug 28, 2009 8:56 am
YTD attributes in fact table

by dennisf
2 Replies
239 Views
Last Posts ngalemmo
Wed Aug 26, 2009 8:58 am
Data Modelling -- linking Header and Detail Fact Tables.

by Sandeep
12 Replies
408 Views
Last Posts sunnys
Mon Aug 24, 2009 5:00 pm
Role differences between facts

by bcm
1 Replies
178 Views
Last Posts ngalemmo
Mon Aug 24, 2009 9:46 am
Loading dimensions

by kruthi
1 Replies
153 Views
Last Posts ngalemmo
Mon Aug 24, 2009 7:47 am
Recursive Hierarchy Data Modelling

by jaiveeru
9 Replies
378 Views
Last Posts jaiveeru
Mon Aug 24, 2009 2:48 am
Dealing with empty/missing dates in dimensions

by Andrea Vincenzi
4 Replies
266 Views
Last Posts Andrea Vincenzi
Fri Aug 21, 2009 8:19 am
Modeling issue

by ric79
2 Replies
178 Views
Last Posts ric79
Thu Aug 20, 2009 9:12 am
Enterprise Date Warehouse/Bus Architecture Physical Implementation

by anandraj
13 Replies
509 Views
Last Posts ngalemmo
Wed Aug 19, 2009 1:25 pm
Modeling for Service related facts and dimension (for Tour Operating Company)

by shajeerkp
4 Replies
246 Views
Last Posts shajeerkp
Tue Aug 18, 2009 12:03 am
Article on the "flaws of the classic dw architecture"

by Andrea Vincenzi
1 Replies
206 Views
Last Posts BoxesAndLines
Sun Aug 16, 2009 5:53 pm
Muliple currencies for periodic snapshot fact table

by cube.head
3 Replies
367 Views
Last Posts ngalemmo
Fri Aug 14, 2009 8:28 am
Daily Snapshots Best Practices

by DilMustafa
2 Replies
256 Views
Last Posts ngalemmo
Tue Aug 11, 2009 8:09 am
reused business keys

by Omaha
7 Replies
209 Views
Last Posts Omaha
Mon Aug 10, 2009 5:50 pm
How to cope with multiply changing history

by malc001
5 Replies
247 Views
Last Posts AmyB
Mon Aug 10, 2009 5:42 am
Language translation for large number of codes

by dennisf
4 Replies
319 Views
Last Posts dennisf
Sat Aug 08, 2009 1:00 pm
Dimensional modeling for operational systems

by celoto
4 Replies
190 Views
Last Posts ngalemmo
Fri Aug 07, 2009 8:20 am
Sales list year over year performance

by barclaywilliams
3 Replies
135 Views
Last Posts ngalemmo
Thu Aug 06, 2009 11:11 am
How to create transactions SCD2 from many SCD tables

by savi176
1 Replies
191 Views
Last Posts ngalemmo
Thu Aug 06, 2009 11:07 am
The great SQL query "template" from edition 1 of Data Warehouse Toolkit

by cube.head
3 Replies
225 Views
Last Posts cube.head
Wed Aug 05, 2009 6:01 am
Example of a business process with more than 1 fact table

by Teto
6 Replies
622 Views
Last Posts Teto
Tue Aug 04, 2009 12:48 pm
Header Level Dimension for a Fact Table

by raghuk
4 Replies
218 Views
Last Posts ngalemmo
Mon Aug 03, 2009 9:34 am
Type 3 Slowly Changing Dimension

by kvkeee
3 Replies
274 Views
Last Posts Edwin Kurian
Wed Jul 29, 2009 2:19 pm
Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

1, 2by Andy Painter
21 Replies
1412 Views
Last Posts ngalemmo
Mon Jul 27, 2009 9:40 am

Page 2 of 5 •

1, 2, 3, 4, 5

• •

Users browsing this forum: None

Moderators

None

Permissions of this forum:

You cannot post new topics in this forum
You cannot reply to topics in this forum

Legend

New posts
New posts [ Popular ]
New posts [ Locked ]

No new posts
No new posts [ Popular ]
No new posts [ Locked ]

Announcement
Sticky