Customer addresses in a high volume retail environment

Guest at 11h58
13
May
2009
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 are:
Current Account Address
Delivery Address
Account Address at time of delivery (may differ from above)
Goods Collection Address (may differ from d

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Addresses in Customer Dimension
As part of an Orders dimensional model, I am attempting to design the Customer Dimension table. The customers have multiple sold-to addresses and multiple ship-to addresses. While the OLTP allows any Order to have any combination of sold-to and ship-to
Guidelines for FACT Table Design for High-Transaction Volume and High # of Measures ...
Hi All - This inquiry could actually be two questions, but the requirement is really presentation of row-wise high volume transactional data in a column-wise (columnar) FACT table. Here is a sample transactional data set: Interval Date TimeUni
Customer Dimension
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship
SRI LANKA GUARDIAN FUND FAVORS BANKS, RETAIL EQUITIES IN POSTWAR ECONOMY
Guardian Fund Management Ltd., which oversees Sri Lanka’s largest listed investment trust, is betting on bank, retail, leisure and construction stocks on optimism the end of the island’s 26-year civil war will bolster economic growth and corporate
De-normalizing Customer Information to create a Customer Dimension
I have a question regarding de-normalizing customer data to create a single customer dimension! Let's say our OLTP customer information is made up of 2 tables. 1) Customer Table (customer name, customer type, etc...) 2) Address Table (address1,
Forums from same category
See also
more_less
Informations

11 Replies For the topic :
"Customer addresses in a high volume retail environment"

This topic has been viewed 2057 times.

Last message :
13/05/2009 at 11h58 by "Guest"