The Problem with developing one off tables

Say you have need for a new table. You make said table. You even like said table, but you design your table for only your use. The problem is, sooner or later someone else is going to find that table, they’re going to look at it and realize that they want to use it too.

So now you have two people using said table, you, and the person who has no idea what the fuck the table actually represents. So be wary of creating tables like that. Sooner or later it will come back to haunt you.

References

• The Data Warehouse ETL Toolkit - pg 49