cancel
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?

Thanks,
Roland

Accepted Solutions (0)

Answers (1)

Answers (1)

TammyPowlas
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.