Data lineage shows the flow of data from source to target. It shows the data flow at the data structure level and at the port level.
The following figure shows the data lineage for a PowerCenter mapping:
The figure shows data structures in the m_customers mapping. The data lineage shows that Customers is in the PowerCenter repository.
The Exp_Customers transformation is expanded, so the data lineage displays the details for Exp_customers, including the ports. The data lineage shows the upstream and downstream fields connected to the ports in Exp_customers. You can display the tooltip for the NEW_CUST_ID port to see the transformation logic.
The direction of the arrows in the data lineage shows the direction of the data flow. In the figure, the data lineage shows that data starts in the Customers source definition, traverses through the mapping, and then gets loaded into the T_CUSTOMERS target.
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.