Showing results for 
Search instead for 
Did you mean: 

House number usage

0 Kudos

Dear All,

I have a question regarding the BP's House number usage. (HOUSE_NUM1)

What do you think, what is the advantages and disadvantages of storing the house number in the Street (STREET) field?


Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

We store our house numbers separately. That way it is easier to see customers by street name, etc. Also it easier (I think) from a data quality side to have those fields separate.