The data I need is out there somewhere, but how do I find it? Data Warehousing provides easy access to the right data at the right time to the right users so that the right business decisions can be made. The Data Warehouse Process is a prescription for identifying strategic business information, collecting it from diverse, enterprise-wide sources, organizing it for instant access to all levels of users according to their specific needs, and implementing the architecture that makes it all possible.
Data Transformation Map
Format: Specifications/ProceduresMap the transformation of the data elements from source system tables to data warehouse target tables. This map includes table, column and field information for source and target systems, so that you can track exactly where each data element is coming from, where it's going to, and how it's transformed in the process.