Chapter 18. Data Lineage

Data Lineage

Starting with Microsoft SQL Server 7.0, Microsoft included the Microsoft Repository for storing and managing meta data, models, components and objects for reusability, interoperability, team development, data resource management, and dependency tracking. The Microsoft Repository is known as Meta Data Services in SQL Server 2000. By using Meta Data Services, you can track the source, transformation, and destination of the data used in the package over time. You will find this capability very useful with data warehousing (refer to chapters 11, 12, and 13). Data lineage that is stored via Meta Data Services can be used to ...

Get SQL Server DTS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.