any time a hierarchy is flattened within denodo - the COLUMN_DEPENDENCIES procedure returns the wrong result (all columns are linked to the flattened column).
unless the COLUMN_DEPENDENCIES procedure is fixed - it might take some heavy lift within the scanner to account for this (e.g. sql parsing).
will be documneted at the moment as a known limitation
any time a hierarchy is flattened within denodo - the COLUMN_DEPENDENCIES procedure returns the wrong result (all columns are linked to the flattened column). unless the COLUMN_DEPENDENCIES procedure is fixed - it might take some heavy lift within the scanner to account for this (e.g. sql parsing).