Comparing Data Lineage and Data Propagation

Data Lineage and Data Propagation have these key distinctions:

• Propagation relates to field expansion (that is, a ripple effect of table column expansion). It encompasses:
• All directions
• All statements

Data lineage diagram



Results should be the same no matter which field is used to start the operation.

• Lineage relates to field route (that is, a table columns origin and movement). It encompasses:
• One direction (forward or backward)
• Optional statements (usually pertinent only to transformation)
• Context sensitive

Data lineage diagram



Results differ depending on seed and direction.