3.2 Defining Catalog Lookup Objects

Catalog Lookup objects can only be defined within the context of a target entity in an ingest connector. Therefore, to create a new catalog object, the user must go to the Ingest Connectors UI and follow the below steps.
  1. Navigate to Home page, under Data Services > Ingest Connectors.
  2. Click Add to display the new connector window.

    Note:

    A Connector cannot be created using only a Catalog Lookup Object. At least one Source External Data Descriptor (EDD) must be defined in the connector.
  3. In the connector canvas, click Target to display all entities.
  4. Drag and drop a target entity (for example, Casa) onto the canvas. Ensure the target entity is successfully placed in the data flow.
  5. Right-click the target entity on the canvas.
  6. From the context menu, select Create Catalog Lookup.
    The Create Catalog Lookup dialog box is displayed.

    Table 3-1 Create Lookup

    Field Description
    Name Enter a name for the lookup.
    Description (Optional) Enter a description in the Description field.
    Context Review the Context field. This field is auto-populated based on the selected target entity and cannot be edited.
    Select the Target Attribute From the Select Target Attribute list, choose the attribute you want to populate using the lookup. A Business Term (BT) from the Target Entity is selected as the Target Attribute for the lookup.
    Lookup Entity Type Under Lookup Entity Type, select one of the following:
    • Dimension: Uses the SCD populated dimension table as the lookup entity. The system automatically selects the Dimension table Business Key and Numeric Identifier as the default key fields for the lookup. For more information, see Using Catalog Lookup with a Dimension Entity.
    • Map: Uses Mapper History entities as the lookup entity. The system automatically selects the Mapper Dimension source fields as the default key fields for the lookup. For more information, Using Catalog Lookup with a Map.
    • Fact: Uses stage entities from the catalog as the lookup entity. The system automatically selects the Stage table Primary Key as the default key field for the lookup. For more information, Using Catalog Lookup with a Fact Entity.
    • Dimension as Sourced: Select this entity type to use Master Data as sourced. The system automatically selects the Stage Master table Primary Key and Numeric Identifier as the default key fields for the lookup. For more information, Using Catalog Lookup with Dimension as Sourced.
    Lookup Entity From the Select Lookup Entity list, choose the entity that contains the reference data.

    Note:

    Only entities that support the selected target attribute are displayed.
    Manual Selection of Group by Key Fields
    • Key fields are auto-selected based on the selected Lookup Entity Type.
    • Users can manually select up to 8 Business Terms (BTs) as Lookup Key Fields.
      • Dimension: Business Key and Numeric Identifier.
      • Dimension as Sourced: Stage Master Table’s Business Key and Numeric Identifier.
      • Fact: Stage Table’s Business Key.
      • Map: Mapper Dimension’s source fields.
    Lookup Value Field From the Lookup Value Field list, select the field whose value will be used to populate the target attribute.
  7. Click Save to save the Catalog Lookup Object details and a confirmation message is displayed. The newly added catalog lookup object is listed in the Catalog Lookup Object Summary page.
    The newly added Catalog Lookup Object is also listed as a new source on the LHS of the Connector User interface in the Data Descriptor list. The Catalog Lookup Objects will appear along with the EDD objects in this list. Each Catalog Lookup Object is represented with an icon marked “CL” in dark blue color to distinguish it from the EDD objects.
    To know more about using catalog lookup object, see Ingesting Data into Data Foundation Cloud Service for Banking.