For a row where the SSIS package lineage is not defined, which value will be represented in Caboodle?

In Caboodle, when a row's SSIS package lineage is not defined, it is represented by the value of -2. This specific value indicates that the lineage is unknown or not applicable, marking a distinction in how data lineage is tracked or recorded.

The use of -2 is significant because it helps maintain the integrity of detected lineage data while clearly denoting instances where lineage information is missing. This can be crucial for data validation processes, troubleshooting, and ensuring that any lineage-related reports accurately reflect the data's origins and transformations.

In contrast, other options like -1, NULL, or Not Applicable serve different purposes or indicate other statuses that do not specifically denote the absence of SSIS package lineage in the same way that -2 does. By employing distinct numerical representations, Caboodle enables users to quickly interpret data lineage status efficiently.