如果对BI报告SalesPerQtr运行数据沿袭分析,将获得如下结果。
If you run a data lineage analysis on the BI report SalesPerQtr, you get the following result.
通过使用扩展映射,就可以对InformationServer外部的数据流执行数据沿袭分析。
By using extension mappings, data lineage analysis can be performed on data flows external to Information Server.
通过使用扩展数据沿袭,不管您使用哪一种流程或应用程序移动或转换您的数据,都可以在整个企业中跟踪数据流。
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.
在创建扩展映射文档以沿着样例存储过程STG_TO_DWH跟踪沿袭后,生成了如图3所示的正确的数据沿袭报告。
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.
这个工作台作为控制站,提供跨工具的影响分析和数据沿袭,为InformationServer提供丰富的报告和管理功能。
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.
研究BI报告、报告字段和数据库列之后,调用数据沿袭报告Wheredoesthedatacome from ?
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报告(比如SalesPerQtr报告)开始的数据沿袭报告将成功展示完整的流程,一直追溯到两个数据源。
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.
MetadataWorkbench用户可以创建数据沿袭报告,分析数据从数据源到作业和准备阶段,再到数据库、数据文件和商业智能化报告的整个流动过程。
Metadata workbench users can create reports that analyze the flow of data from data sources, through jobs and stages, and into databases, data files, and business intelligence reports.
Workbench的作用是在来自各个来源的数据之间建立自动的链接,提供有用的沿袭报告和影响分析信息。
Workbench plays a critical role in establishing the automated link between the data from various sources and provides useful lineage reports and impact analysis details.
因此当来自临时数据库的信息通过存储过程被转移到数据仓库中时,这个沿袭出现了一个断点。
So when information from the staging database is moved to the data warehouse through stored procedures, there is a gap in the lineage.
然而,如果所需的沿袭报告只需要指出报告源自哪一个数据库,那么则根本不需要在更细粒度级别上归档。
However, if the level of required lineage reporting is only to the level of which database a report is sourced from, then there might not be any need to document to a finer level of granularity.
MetadataWorkbench的核心特性之一就是它的一项内置支持,即在由InformationServer组件创建或导入的元数据之间自动推断沿袭关系。
One of the core features in metadata Workbench is its built-in support to automatically deduce linkages among metadata that Information Server components create or import.
来自CognosBI的报告元数据、来自DataStage 的ETL作业元数据和来自 DataStage 的仓库元数据需要相互映射,以便能够通过沿袭报告跟踪它们。
The report metadata from Cognos BI, ETL job metadata from DataStage, and the warehouse metadata from Database, need to be mapped to each other to enable traceability through lineage reports.
“哪些系统维护公共数据”,“数据的沿袭是怎样的?”
“哪些系统维护公共数据”,“数据的沿袭是怎样的?”
应用推荐