3.2.4 Using Catalog Lookup with Dimension as Sourced

Uses master data directly from the stage master table to fetch attributes from dimension as sourced tables.

1. Create a Catalog Lookup Object in the Data Service and select the required Dimension as Sourced (for example, Data Source for Dimension).
2. Define the key field (for example, Product Code) and select the lookup field to retrieve (for example, As of Date).
3. In the Connector Source configuration, add the Source EDD and the Catalog Lookup Object.
4. Add a Aggregation condition between the source field and the lookup key field (for example, Data Source for Dimension as Source = Data Source Numeric Identifier (ADI).
5. In Mapping, map the retrieved lookup value (for example, Data Source) to the required target field.