Generates a query or DW query for each matched entity.

Label

Description

Match for entity

Select the criteria for finding the matching entities from the drop-down list. Refer to Model Conversion Matching Criteria for details.

Match source set

Select the matching source set name using a template. The following variable is available:

  • sourceSet: The source set object of the matched entity.
    The default value "- sourceSet.name.matches(".") -{*}" can be used to generate queries for all available source sets.

Action

Which queries to process:

  • Populate queries: Generates the queries.
  • Delete queries: Deletes the queries.
  • Populate DW queries: Generates the Data Warehouse queries.
  • Delete DW queries: Deletes the Data Warehouse queries.

Populate

When to generate queries:

  • Ignore existing queries: Only generate a query for the entities that do not have one defined.
  • Overwrite existing queries: Always generate a query for the entities.

Template

Select a template to use when generating this model conversion.

Force chosen template

Check to force the selected template to be used. If this option is not selected, the matched entities' set template will be used to generate the query.

Encapsulate schema name

Define the values for the pre-declared Pebble parameters ECS_SO and ECS_SC used when generating a DW query. In the RED Export category the values used will be '[' and ']' regardless of the values specified in the model conversion rules configurations.

Encapsulate entity name

Define the values for the pre-declared Pebble parameters ECS_TO and ECS_TC used when generating a DW query. In the RED Export category the values used will be '[' and ']' regardless of the values specified in the model conversion rules configurations.

Encapsulate attribute name

Define the values for the pre-declared Pebble parameters ECS_CO and ECS_CC used when generating a DW query.

Encapsulate alias

Define the values for the pre-declared Pebble parameters ECS_AO and ECS_AC used when generating a DW query.

Copy WHERE clause from query tab

The pre-declared Pebble parameter copyQueryWhereClause, used when generating a DW query, will be set to true or false depending on whether this checkbox is checked or not.

  • No labels