Order Line Fact

Order Header fact and multiple payment methods

I need some help in designing this particular situation. Here are some details: 1)The grain is one row per order 2)Each order can have multiple payment methods ex: cash,credit card,customer account,due bill,gift card 3)A combination of payments is

Model for these charges

Orders Fact Table

I've been reading more and more Kimball literature and I'd like clarification on something. Transaction Fact Tables are rarely revisited because they do not need to be updated, deleted, etc but typically only appended to. He goes on to describe

Modeling Descriptive Flex Fields (Attribute Columns) on an Order Line

For an order line that contains 15 generic attribute columns, how would one model all the miscellaneous data elements (i.e Vendor SKU, Customer Part Number, RMA Product Condition, etc) to make it available to end users as part of the order fact

Transaction Fact design

hi I am faced with a problem designing a transaction fact in an investment firm. each transaction represents a trade the traders put in (buy,sale etc). The problem I am facing is: the metrics of a transaction change from one day to another day so a

OOCL plans order for 13,000 TEU ships

Orient Overseas Container Line (OOCL), the Tung-family-controlled shipping company, could order massive container ships that would be almost 50 per cent bigger than any ship in its fleet, a senior executive confirmed. Such a move would reflect the

Unusual Head Line

Unusual Head Line Note: Images would be only for viewing and would not be discussed.

Movement order

To Colonel von Braunschweig-Wolfenbüttel, 1st Line Battalion King's German Legion, You are hereby directed to move with two companies to the vanguard. You will assume responsibility for establishing forward picquets and maintaining advance guard. If

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Pete Turner Appreciation Thread

Thought that it was unfair that Guy, Craig, and Richard had one and Pete and Mark didn't so i have taken it upon myself to sort that:P

Signature Line Links

According to the new editable signature line divider, you are allowed [img] tags and [center] tags, and no HTML. So, why not more? I think at least the [url] tag should be included so that would mean you could have a mini global update link in every post.

Affordable triptans?

Hi all- I am getting really concerned about my situation - I was getting enough relief from a combo of Neurontin and amitriptyline that I was able to get by on the small amount of Maxalt that Medicaid allows me. But when the combo quit, about three