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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.