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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Cartesianjoin
- Order by date
-
Combining Sales fact with Cash Receipts Fact
A salesrep has the ability to issue a discount associated with an entire order and not to a specific item on the order. The discount is entered as a customer credit to the AR / billing system matched to the orderId # and is mapped to a salesrep discount type along with a comment reason. For me...- Cartesianjoin
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
-
Address Dimension /multiple addresses
We have a sales fact table and have a question with the customer and address dimension. A customer can have more than one address for shipping and billing (think large company with many locations). Each sale need to be tracked to the main parent company and to the specific location or division...- Cartesianjoin
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
