Dispatch Fact Tables
3 posters
Page 1 of 1
Dispatch Fact Tables
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
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
Re: Dispatch Fact Tables
Copied as in the two fact tables share common dimensions? Then yes.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Difference between Aggregate Fact Tables, Rollup Tables and OLAP Cubes ?
» Storing Date Keys in dimension tables versus fact tables
» Multiple Fact tables, Aggregate tables or a different approach
» Number of Columns in Fact Tables vs. Dimension Tables
» Difference between Aggregate Fact Tables, Rollup Tables and OLAP Cubes ?
» Storing Date Keys in dimension tables versus fact tables
» Multiple Fact tables, Aggregate tables or a different approach
» Number of Columns in Fact Tables vs. Dimension Tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum