Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Vendor Emails

4 posters

Go down

Vendor Emails Empty Vendor Emails

Post  BIDW 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

Back to top Go down

Vendor Emails Empty Re: Vendor Emails

Post  BoxesAndLines Tue Jun 16, 2015 7:51 am

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

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

Back to top Go down

Vendor Emails Empty Re: Vendor Emails

Post  BIDW Tue Jun 16, 2015 1:44 pm

Any other suggestions guys!

BIDW

Posts : 25
Join date : 2015-01-18

Back to top Go down

Vendor Emails Empty Re: Vendor Emails

Post  gvarga 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

Back to top Go down

Vendor Emails Empty Re: Vendor Emails

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Vendor Emails Empty Re: Vendor Emails

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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