Hi All,
I am stuck up with some logic here, can any one suggest me what would be the best solution or how can we acheive this.
We have a customer id's , each customer can have many accounts, and the customer belongs to a company.I need to modify a SQL table to group slightly mismatched names, and assign all elements in the group a standardized name.
I have a customer table where I used select customer_id,customer_code,customer_name from customer order by 1; These are only few records I am showing here.
| CUSTOMER_ID | CUSTOMER_CODE | CUSTOMER_NAME |
|---|
| 071239 | AABA | Trac Non Owned Chassis |
| 078176 | AABA | Trac Charleston |
| 071910 | AABA | Trac Savannah |
| 081010 | ABAA | Hanjin Shipping |
| 081102 | ABAA | Atg |
In this case, I've chosen the first name to assign as the "standardized name," but I don't actually care which one is chosen .If I knew that the names were all in pairs, this would be a relatively easy query, but there can be an arbitrary number of the same name.
And I am using SQL DEVELOPER, for Oracle data integrator(ODI)
Thanks,
Ven