Transformation Server also includes built-in filtering and selection capabilities that enable companies to exclude certain data elements from the warehouse. This ensures that sensitive or irrelevant data is filtered out and users have access to only the information they need. Metadata Management Metadata management is absolutely essential to ensure a successful business intelligence or CRM implementation. How well the data replenishment solution you choose manages metadata will directly affect the performance of presentation tools and the overall effectiveness of the data warehouse. Metadata allows business users as well as technical administrators to track the lineage of the data they are using by providing information about where the data came from, when it was delivered, what happened to it during transport, and other descriptions which can be tracked.
Decision makers can get a clear understanding of the data on which their decisions are based.
Transformation Server provides breakthrough metadata management capabilities afforded through Version 2.2 of its Enterprise Administrator graphical user interface. Using Transformation Server, organizations can now view their entire replication network in a single snapshot and easily export metadata to another repository such as Microsoft Repository or directly into end user query and analysis tools. Without this functionality, companies often must resort to time-consuming custom development that may negatively impact time to market. Other replenishment solutions provide access to metadata using proprietary programmatic interfaces or formats that are difficult to integrate and manage without custom coding. By contrast, DataMirror Transformation Server offers a truly open solution based on industry standards that addresses the challenges of standardizing metadata across different applications and databases.