Current date/time is Sat Nov 07, 2009 7:48 am

Dimensional Modeling and Data Architecture

• Page 1 of 5 • 1, 2, 3, 4, 5

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

Topics
Replies
Views
Last Posts

Eliminate Date Dimension Surrogate Key

by juz_b
0 Replies
8 Views
Last Posts juz_b
Yesterday at 1:57 pm
Model for storing dimension attributes in multiple languages

by jefoster
1 Replies
23 Views
Last Posts ngalemmo
Thu Nov 05, 2009 9:16 am
SCD's and Fact Tables

by jimbo1580
1 Replies
34 Views
Last Posts ngalemmo
Wed Nov 04, 2009 10:19 am
Customer Dimension

by kenny
3 Replies
64 Views
Last Posts jimbo1580
Tue Nov 03, 2009 3:16 pm
Flat Table vs star schema

by bi_at_nj
3 Replies
59 Views
Last Posts cridal
Tue Nov 03, 2009 1:45 pm
Modeling Question - Accumulating Snapshot vs. Event Transactions

by jimbo1580
4 Replies
73 Views
Last Posts cridal
Tue Nov 03, 2009 1:18 pm
Snowflake scenarios

by bi_at_nj
2 Replies
43 Views
Last Posts ngalemmo
Tue Nov 03, 2009 9:10 am
Date Dimension

by mark.tan
9 Replies
179 Views
Last Posts ngalemmo
Mon Nov 02, 2009 9:19 pm
Partitioning Strategy for Fact and Dims in Oracle/DB2/Sybase

by bi_at_nj
3 Replies
34 Views
Last Posts ngalemmo
Mon Nov 02, 2009 12:21 pm
Fact Table Indexing Strategy

by bi_at_nj
2 Replies
50 Views
Last Posts BoxesAndLines
Mon Nov 02, 2009 11:46 am
Geospatial Modeling

by tlfancher
0 Replies
15 Views
Last Posts tlfancher
Mon Nov 02, 2009 6:09 am
Dimension Table Indexing Strategy

by bi_at_nj
1 Replies
23 Views
Last Posts gerardnico
Sat Oct 31, 2009 7:29 am
Sybase Databases in BI world?

by bi_at_nj
0 Replies
17 Views
Last Posts bi_at_nj
Fri Oct 30, 2009 11:36 pm
Version Controlling your Data models

by bi_at_nj
0 Replies
13 Views
Last Posts bi_at_nj
Fri Oct 30, 2009 11:32 pm
eacoe training?

by bi_at_nj
0 Replies
14 Views
Last Posts bi_at_nj
Fri Oct 30, 2009 11:30 pm
Database by name KDB ?

by bi_at_nj
0 Replies
16 Views
Last Posts bi_at_nj
Fri Oct 30, 2009 11:28 pm
Specify acceptable Snowflaking scenarios

by bi_at_nj
0 Replies
15 Views
Last Posts bi_at_nj
Fri Oct 30, 2009 9:49 pm
Sybase Indexes

by bi_at_nj
0 Replies
9 Views
Last Posts bi_at_nj
Fri Oct 30, 2009 9:47 pm
Many to many relationship question

by ekv11
7 Replies
64 Views
Last Posts ekv11
Wed Oct 28, 2009 12:42 pm
many to many relationship between dimension level

by GBS74
3 Replies
75 Views
Last Posts ngalemmo
Mon Oct 26, 2009 2:27 pm
One to many relationships

by Martijn Kamerbeek
6 Replies
107 Views
Last Posts ngalemmo
Mon Oct 26, 2009 2:23 pm
Facts with different grain from different sources but related

by mranjank
2 Replies
44 Views
Last Posts mranjank
Mon Oct 26, 2009 8:47 am
Dimension as a Fact

by Irtaza Hassan
1 Replies
53 Views
Last Posts Irtaza Hassan
Mon Oct 26, 2009 7:12 am
Modelling help for multiple level facts

by terry_stjean
0 Replies
34 Views
Last Posts terry_stjean
Fri Oct 23, 2009 6:32 am
Modeling a fact with multiple sources

by schnedar
4 Replies
180 Views
Last Posts BrianJarrett
Fri Oct 23, 2009 6:30 am
Hierarchy within single dimension or two dimensions

by jimbo1580
3 Replies
62 Views
Last Posts BrianJarrett
Fri Oct 23, 2009 6:14 am
Pipeline with Accumulating snapshot

by sr_da
2 Replies
77 Views
Last Posts sr_da
Wed Oct 21, 2009 9:33 am
Combining Facts

by cbusch
2 Replies
70 Views
Last Posts ngalemmo
Wed Oct 21, 2009 8:39 am
Data Warehouse Purge Strategy - HELP

by AndyPainter
3 Replies
64 Views
Last Posts ngalemmo
Wed Oct 21, 2009 8:19 am
Subscription as an Accumulating Snapshot Fact or a Dimension?

by Irtaza Hassan
4 Replies
62 Views
Last Posts Irtaza Hassan
Mon Oct 19, 2009 2:48 pm
Millions of client information that can not be uniquely identified

by hennie7863
3 Replies
68 Views
Last Posts BoxesAndLines
Mon Oct 19, 2009 1:43 pm
Start schema in relational database vs OLAP

by dellsters
5 Replies
297 Views
Last Posts ngalemmo
Sat Oct 17, 2009 12:56 am
Best Practices for SCD Dimension Tables for a Banking Data Warehouse

by IJohnson
1 Replies
94 Views
Last Posts pcs
Fri Oct 16, 2009 2:01 pm
Measures as special dimension table

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

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

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

by jochem_van_grondelle
10 Replies
287 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
49 Views
Last Posts abachwani
Wed Oct 14, 2009 4:09 pm
INDEXING IN WAREHOUSE AND BUSINESS INTELLIGENCE

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

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

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

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

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

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

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

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

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

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

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

by raghuk
3 Replies
199 Views
Last Posts ngalemmo
Fri Sep 18, 2009 11:25 am

Page 1 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