Column Property Enforcement

Go down

Column Property Enforcement  Empty 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
davidp
davidp

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

Back to top Go down

Column Property Enforcement  Empty 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.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Column Property Enforcement  Empty 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Column Property Enforcement  Empty Re: Column Property Enforcement

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

OK, got it - thanks.

David
davidp
davidp

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

Back to top Go down

Column Property Enforcement  Empty Re: Column Property Enforcement

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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