Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Dispatch Fact Tables

Kimball Forum :: Topics :: Business Requirements and Program / Project Management

Go down

Dispatch Fact Tables Empty Dispatch Fact Tables

Post  evancamilleri on Fri Mar 01, 2013 6:14 am

I have a 'SalesOrdersFact' table and want to do 'SalesDispatchesFact' Table

I order can have multiple dispatches.

I assume that I do not link them and some fields in the SalesOrdersFact table have to be copied in the 'SalesDispatchesFact' Table

evancamilleri

Posts : 1
Join date : 2013-03-01

Back to top Go down

Dispatch Fact Tables Empty Re: Dispatch Fact Tables

Post  Mike Honey on Wed Jun 19, 2013 12:36 am

Probably.
Mike Honey
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

http://www.mangasolutions.com

Back to top Go down

Dispatch Fact Tables Empty Re: Dispatch Fact Tables

Post  BoxesAndLines on Wed Jun 19, 2013 10:17 am

Copied as in the two fact tables share common dimensions?  Then yes.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Dispatch Fact Tables Empty Re: Dispatch Fact Tables

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

Kimball Forum :: Topics :: Business Requirements and Program / Project Management

 
Permissions in this forum:
You cannot reply to topics in this forum