Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by DBArch
-
Order header amount fields
Thanks Kishleo and John for your input and suggestions. It seems there are at least 3 alternatives, each placing the over all order's shipping charges, etc, into a fact table. One: We could create a separate line-item for shipping charges and place this in the main fact table. Not sure I like...- DBArch
- Post #4
- Forum: Data Warehousing/Big Data
-
Order header amount fields
Hi, We're in the process of designing an Orders Data Mart and I have a basic question on what to do with order-header type information such as Misc. Charges and Freight Charges. Do these belong in a separate 'order dimension' along with Order number, Order Date, etc.; or, should this...- DBArch
- Thread
- Replies: 4
- Forum: Data Warehousing/Big Data
