Multiple Mapping and Union - discovery - 23.1

Spectrum Discovery Guide

Product type
Product family
Spectrum > Discovery
Product name
Spectrum Discovery
Spectrum Discovery Guide
Topic type
How Do I
First publish date

You can map a logical model multiple times, making it possible for you to pull data for an entity in your logical model from multiple physical models. For example, ID and firstName of Customer entity in your logical model can be mapped to Customers_PostgresPhysicalModel in Mapping1 and Customers_FrameworkSplunkPhysicalModel in Mapping2.

You can later perform a union operation on Mapping1 and Mapping2 to combine the ID and firstName data in both the mappings, and use this combined data for other functions, such as profiling.

To map a logical model, perform these steps:
  1. On the Logical Model tab of the Modeling page, select the logical model to be mapped, and follow the steps described in Mapping through drag drop on canvas.
  2. To view the multiple mappings for your logical model, click . The mappings are displayed under the Mapping Name column. The mapped physical models and last modified date and time of the respective mappings are also displayed.
    Note: The first mapping created on a logical model is its default mapping and is flagged out under the Actions column. This is the mapping that becomes available in the model store by default when you select this logical model during model store creation.
  3. To change the default mapping of a logical model, flag it out in the Actions column.

To perform union of mappings, follow these steps:

  1. Select the required logical model, and click the Create Union icon in the tool bar.
    Note: The Create Union icon is enabled only for those logical models that have more than one mappings.
    The Create Union pop-up window appears.
  2. In the Name field, enter a name for this union.
  3. From the Type option button, select if you want to perform Union or Union All operation.
    Note: Union removes the duplicate rows while Union All operation retains those.
  4. From the list below Select mapping, select the model maps on which you want to perform union, and click Create Union.
    The union is saved and you are navigated back to the Modeling page.
  5. To view the union, click corresponding to the logical model.
    The union is listed along with the mappings in the Mapping Name column. The union icon distinguishes it from the mappings of the logical model.
Tasks that you can perform on the mappings and unions created on your logical model:
  • Profile any of your mappings or union: To do this, click the corresponding Profile icon. For details on profiling, see Creating a Profile.
  • Delete any of your mappings or union: To do this, click the corresponding Delete icon.
    Note: If the mapping you want to delete is used in any union, those unions will need to be deleted before the mapping.