A retail bank discovers that an interest-accrual amount shown on a regulatory report is overstated. Auditors request proof of exactly how the numeric value moved from a raw transaction record through each ETL step and calculation to the final report column. Which type of data-lineage metadata will provide the level of detail required to satisfy this SOX audit?
Dataset-level business lineage that maps tables to the departments that consume them.
Column-level technical lineage that records every field transformation, code version, and parameter value.
A high-level architectural diagram of sources, staging areas, and presentation layers.
Aggregate ETL runtime logs that list job status and execution duration.
Only column-level technical lineage captures every transformation applied to an individual field-including the specific code version, formulas, and parameter values-so investigators can reproduce and verify the value's journey end-to-end. Higher-level business lineage, aggregate job logs, or architectural diagrams lack the fine-grained, field-level traceability needed for compliance and root-cause analysis.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is column-level technical lineage?
Open an interactive chat with Bash
How is column-level technical lineage different from dataset-level business lineage?
Open an interactive chat with Bash
Why is column-level technical lineage important for SOX compliance?