Tech·Ed Europe 2010

Finally: Data Lineage in Business Intelligence Projects with SQL Server Metadata Toolkit 2008

Download this episode

Download Video

Description

Do you always have to answer questions such as: ‘What ERP column does this dimension attribute come from?’ ‘Were there any changes in the calculations compared to last month?’ Most data-warehousing professionals are familiar with the concept of data lineage. Data warehouses are very often accountable for tracking whatever alterations upstream data is subjected to, once it crosses over into the data warehouse environment. SQL Server Metadata Toolkit, a free community tool, can track these alterations within an ETL and cube-environment by scanning SQL Server metadata and presenting a series of data output-input dependencies as a graph of nodes and links.

Day:

40

Code:

BIN308

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.