全部

1·Data lineage to understand where data is originating from.

通过数据衍生关系了解数据的起源。

2·If you run a data lineage analysis on the BI report SalesPerQtr, you get the following result.

如果对BI报告SalesPerQtr运行数据沿袭分析，将获得如下结果。

3·By using extension mappings, data lineage analysis can be performed on data flows external to Information Server.

通过使用扩展映射，就可以对Information Server外部的数据流执行数据沿袭分析。

4·With extended data lineage, you can track the flow of data across your enterprise, no matter which process or application is moving or transforming your data.

通过使用扩展数据沿袭，不管您使用哪一种流程或应用程序移动或转换您的数据，都可以在整个企业中跟踪数据流。

5·Figure 3 shows the corrected data lineage report after creating an extension mapping document to track the lineage through the example stored procedure STG_TO_DWH.

在创建扩展映射文档以沿着样例存储过程STG_TO_DWH跟踪沿袭后，生成了如图3所示的正确的数据沿袭报告。

6·After having gained insight into the BI report, report fields, and database columns, the staff member invokes a data lineage report called Where does the data come from?

研究BI报告、报告字段和数据库列之后，调用数据沿袭报告Where does the data come from ？

7·Acting as a control station, the workbench provides cross-tool impact analysis and data lineage, as well as extensive reporting and administration functions for Information Server.

这个工作台作为控制站，提供跨工具的影响分析和数据沿袭，为Information Server提供丰富的报告和管理功能。

8·Therefore a data lineage report started on one of the BI reports, such as the SalesPerQtr report, would successfully report the entire flow all the way back to the two data sources.

因此，从某个 BI 报告（比如 SalesPerQtr 报告）开始的数据沿袭报告将成功展示完整的流程，一直追溯到两个数据源。

9·ETL tools like SSIS can perform these functions such as moving data between systems, reformatting data, integrity checking, key lookups, tracking lineage, and more.

像SSIS这样的ETL工具就可以实现这些功能，如，在不同的系统间进行数据的移动、数据的再格式化、完整性校验、关键值查询、衍生跟踪等，SSIS也证明了它是一个有能力和有着多方面用途的ETL工具。

10·So when information from the staging database is moved to the data warehouse through stored procedures, there is a gap in the lineage.

因此当来自临时数据库的信息通过存储过程被转移到数据仓库中时，这个沿袭出现了一个断点。