Normalization

[#1]

Hi

I have to make a Data Consistency i.e Normalization(one to one relation). Pls check below data format & suggest me

Vendor          VendorID     Country

BHARTI        001                India

BHARTI        002                USA

BHARTI        004                Singapore

E&Y              033                India

MID               033                Malaysia

IGATE           071                USA

V-IGATE       071                 India

this format is within the same excel. I should not change the raw data. And it has to change dynamically when new vendor adds. when i select on country it is showing one to one relation but my dougth is vendor & vendorID is same for any country????

[swuehl]

Hard to tell a suggestion.  You have used different Vendor names for the same VendorID as well as different VendorIDs for the same Vendor name.

Both might have reasons in your business.

You need to clarify for example:

- Can vendor name change over time? If so, how would you like to handle this? (Look into strategies for slowly changing dimensions)

- which name do you want to see e.g. for 71?

- Could different vendors have the same name? So they are only differentiated by VendorID? Maybe if you want to differentiate branches of a vendor, like local sub-organizations?

- If different vendors can't have same name, what is the leading field in your table? do you want to assign all BHARTI the same VendorID (which one)? Or change the name of two of the BHARTI (to which name)?

Before anyone can suggest a script code, you need to define the business logic.

[Anonymous]

Agreed with swuehl

You need to share the business logic for same...

If it is just about getting 1 ID for 1 Vendor.

Then decide, you want to assign a max(), min(), FirstValue(), Lastvalue() which you can do by taking resident of same