I worked on an OLAP based product until 3 years ago. The source data was in a lotus notes application that was updated by nearly 100 different researchers. We i

I worked on an OLAP based product until 3 years ago. The source data was in a lotus notes application that was updated by nearly 100 different researchers. We imported the lotus notes data into our data warehouse every night. I can't tell you how many times we had problems because data had been entered in a different format. Schema-less might have it's place but I definitely wasn't seeing the benefits on that job!