Vendor Emails

View previous topic View next topic Go down

Vendor Emails

Post  BIDW on Mon Jun 15, 2015 6:37 am

Guys I have a vendor dimension with one row per vendor. It has email address which basically picks up the last one entered. Currently the business has requested all email addresses to be returned instead of one. What is the best way to handle this in the data model. I don't think flattening would be a good option because sometimes a vendor may have even 5 email addresses.

Thanks

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Vendor Emails

Post  BoxesAndLines on Tue Jun 16, 2015 7:51 am

Sounds like a good use of type 3 SCD. Flatten away!
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Vendor Emails

Post  BIDW on Tue Jun 16, 2015 1:44 pm

Any other suggestions guys!

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Vendor Emails

Post  gvarga on Wed Jun 17, 2015 3:22 am

Email adresses are descriptive attributes and the user just wants to read them.
I see the following options:
1. In your database you will have a table emails: as many rows as the vendor has.
If the user wants to see all these emails and the BI tool allows, you can creat a new page showing emails and the user can navigate to this information ( In Oracle BI for instance)
2. If there is no possibility, you can have an EMAILS attribute in Vendor dim table, where all the emails are stored. In this case you have just to show this column with the concatenated email addresses
3. Or you can combine the 2 solutions
4. Or create 2 columns for emails: MAIN (LAST)EMAIL, PREVIOUS EMAILS

gvarga

Posts : 43
Join date : 2010-12-15

View user profile

Back to top Go down

Re: Vendor Emails

Post  ngalemmo on Wed Jun 17, 2015 8:45 am

Just have an outrigger table with the vendor key and the email address. If there are significant other attributes for the email address you may consider a formal email dimension and a vendor/email bridge table. You may also consider a flag or timestamp to identify the most current address.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Vendor Emails

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum