Guidelines for FACT Table Design for High-Transaction Volume and Hi...

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

Fact table design: Sales Transaction with multiple Discount rows

Hi, I am designing a Sales DW where we can have multiple discounts on a given transaction line. I created a SalesTransaction (ST) fact table and a SalesDiscount (SD) fact table. In the current design the ST table has its own key that is a bigint

Customer addresses in a high volume retail environment

I have a requirement to start capturing addresses in our data warehouse for detailed analysis of customer returns. Up until now, analysis at postal code has been sufficient. The company I work is mail order, so the addresses I need to record

makeing a stand for star schema design

Hi, I am new to a financial company and I was asked to model two new sources of data in the existing mortgage data mart (not too sure if you could actually call it a datamart after seeing the design), basically I was asked to create detail information

Transaction fact table and Transaction line item fact table

Hello, i am building a data warehouse for an ecommerce shop. My first idea was to follow the best practices to make a fact table on line item level. But my boss doesn't want the costs for coupons, vouchers, etc allocated on item level. That is why I

JVC GC-PX1 High Speed Camera

According to JVC’s Japanese website, the camera is real and will be available in Japan this month. JVC GC-PX1 Key Features * 10.6MP Back-illuminated CMOS Sensor * 10x Optical Zoom Lens with OIS * 1920 x 1080 Full HD Video at 60p /

Create a High Rise Building In Blender 2.5

Part 1 Create a High Rise Building - Part 1 of 2 from Andrew Price on Vimeo. Part 2 Create a High Rise Building - Part 2 of 2 from Andrew Price on Vimeo.

Why jordan shoes are so high profile

The end of the sweltering summer nears, are the most popular shoes in this summer.When it comes to Nike,which is the most popular sport shoes brand,everyone should fond of it.Why are so high profile?The reason is not just for its good reputation,but

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

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

alma mater (college ito!!!) malay mo, school mates pala tau!!!

hello guys and girls! let's talk about college life... your school, your course.. kahit wag ng batch... you may also add your most unforgettable, most embarrassing, happiest, loneliest at kung ano ano pang superlatives

Cute ang Pinakahuling mag post.

Cute ang Pinakahuling mag post. ehem...

describe the poster above

so the title says it, before you post, you just need to describe the poster/people above you example user1 user2:has 10 posts user3:is kind user 4: has no avatar and so on so let's start on me

Guidelines for FACT Table Design for High-Transaction Volume and High # of Measures ...