We've got a problem with entities having different names across different teams in the same business. To compound the issue, tables in the data warehouse have the same names as tables in the OLTP system but hold different data.
We have two types of 'task', one which is related to contacting a client and another that is related to jobs that are done when a client is visited. There is a 'contact' table on our CRM system that holds data about each client but the contact table in the data warehouse holds data about 'contact' with a client. These are known as tasks elsewhere. As you can imagine there is potential for confusion and frustrating calls when one side or another isn't explicit about what they are talking about.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537