Column Property Enforcement

View previous topic View next topic Go down

Column Property Enforcement

Post  davidp on Wed Apr 23, 2014 8:21 am

I have a question on one of the screens/ data quality checks listed under the "Column Property Enforcement" category in the book ("The ETL Data Warehouse Toolkit" Chapter 4, Part 3, page 134)
I understood 6 of the 7 screens listed, but the following one is not clear to me:

"Hits against a list of known wrong values where list of acceptable values is too long"

An example or a clear explanation would be greatly appreciated.

Thanks,
David
avatar
davidp

Posts : 2
Join date : 2014-04-03
Age : 55
Location : Israel

View user profile

Back to top Go down

Re: Column Property Enforcement

Post  BoxesAndLines on Wed Apr 23, 2014 1:07 pm

My guess is the set of valid values is too great to list. Instead, here are some commonly used invalid values.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Column Property Enforcement

Post  ngalemmo on Wed Apr 23, 2014 5:13 pm

For example, looking for obscene words or bogus addresses. The list of all permissible words is very long, whereas the list of impermissible words is a lot shorter.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Column Property Enforcement

Post  davidp on Thu Apr 24, 2014 2:01 am

OK, got it - thanks.

David
avatar
davidp

Posts : 2
Join date : 2014-04-03
Age : 55
Location : Israel

View user profile

Back to top Go down

Re: Column Property Enforcement

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