hi,

Before you load you data to your warehouse, you need to check the same version of the data is available in target,

To compare your ODS and data warehouse/data mart you are using the lookup transformation

Cheers,

Sithu, sithusithu@hotmail.com