Define ETL entity mappings

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • Map the source entity to a target entity.

    Before you begin

    Role required: import_transformer

    About this task

    You can optionally set the Ignore check box to exclude the entity mapping when performing data integrations using Robust Import Set Transformation (RTE).

    Procedure

    1. Navigate to All > System Import Sets > Administration > ETL Definitions.
    2. Select an ETL definition.
    3. On the RTE Entity Mappings tab, click New.
    4. Complete the form.
      Field Description
      Name Name of the mapping.
      Source Entity Source entity for the mapping.
      Target Entity Target entity for the mapping.
      Order Order in which the mapping should be processed.
      Is Conditional Check box that designates that the mapping is conditional. Select the check box if the mapping is conditional and clear it if it is not.
      Condition Script Script that defines the conditions that must be met for the mapping. For an example of a conditional script, see Temporary entity model.
      Application Application scope for this record.
      Definition Selected ETL entity that this mapping belongs to.
      Ignore Check box that designates if this ETL entity mapping should be ignored when performing data integrations using Robust Import Set Transformation (RTE).

      Select this check box if this ETL entity mapping should be ignored when running data integrations using RTE. Clear the check box if it should not (default).

      To learn more about data integrations, see: