Creating a New Table Population

A Table Population can be created by either:

  • Dragging the table from the LU Schema DB Objects tab into the LU schema working area to create the LU table including its Table Population object.
  • Creating an LU table using the New Table from SQL Based DB Query or New Table from SQL Based Root Function options in the LU Schema window to create the LU table including its Table Population object.
  • Using the Auto Discovery Wizard to automatically create the LU table and a DB query population for each LU table.
  • Manually, by right clicking the [Table Name] under the Project Tree and then clicking New Table Population.

LU tables can be populated by either a DB query or a Root function source object. To decide which source object to use, refer to the comparison analysis of Table Population Source Object Types.

A source object can return one or many records whereby each output record is mapped and populated into a target LU table. Note that a Table Population can extract data from other LU tables in the same Logical Unit. It is recommended to always check the execution order of a source table’s population objects to verify that the source LU tables are populated before the target LU table. For example, the SUBSCRIBER LU table must be populated before the OFFER LU table to enable populating the OFFER LU table based on data from the SUBSCRIBER LU table.

When an LU table has two populations, a second Table Population can extract data from the same LU table. For example, the ADDRESS LU table has two Table Populations:

  • Population 1 extracts data from the CRM DB.
  • Population 2 extracts data from the ADDRESS LU table that has been inserted by Population 1.

Click for more information about Creating Table Population Objects.

How Do I Create a New Table Population From a DB Query?

  1. Go to Project Tree > Logical Units > [LU Name].
  2. Click Tables, right click [Table Name] > New Table Population to open the working area for creating the mapping.
  3. Click the Objects tab in the right panel of the Table Population working area.
  4. Click Databases to display the list of interfaces defined in the project or a built-in Fabric interface.
  5. Double-click on the required table name or drag it into the working area.
  6. Click Create as DB Query to create the DB query source object in the working area.
  7. Optional: use the Edit Query option to edit the input query via the Query Builder, for example, to choose specific columns or conditions in SQL statements. Do either:
    • Click the source object, then go to the Properties tab > Edit Query in the right panel of the working area.
    • Double click the source object.
  8. To connect the source object to the target LU table, right click the DB Query object and either:
    • Click Auto Connect to Table.
    • Connect the fields manually.

How Do I Create a New Table Population From a Root Function?

  1. Go to Project Tree > Logical Units > [LU Name].
  2. Click Tables, right click [Table Name] > New Table Population to open the working area for creating the mapping.
  3. Click the Objects tab in the right panel of the Table Population working area.
  4. Click Root Functions and do either:
    • Select an existing Root function and drag it into the working area.
    • Click Create New Root Function.
  5. Right click the source object and do either:
    • Check Auto Connect to Table.
    • Connect the fields manually.

Previous

Creating a New Table Population

A Table Population can be created by either:

  • Dragging the table from the LU Schema DB Objects tab into the LU schema working area to create the LU table including its Table Population object.
  • Creating an LU table using the New Table from SQL Based DB Query or New Table from SQL Based Root Function options in the LU Schema window to create the LU table including its Table Population object.
  • Using the Auto Discovery Wizard to automatically create the LU table and a DB query population for each LU table.
  • Manually, by right clicking the [Table Name] under the Project Tree and then clicking New Table Population.

LU tables can be populated by either a DB query or a Root function source object. To decide which source object to use, refer to the comparison analysis of Table Population Source Object Types.

A source object can return one or many records whereby each output record is mapped and populated into a target LU table. Note that a Table Population can extract data from other LU tables in the same Logical Unit. It is recommended to always check the execution order of a source table’s population objects to verify that the source LU tables are populated before the target LU table. For example, the SUBSCRIBER LU table must be populated before the OFFER LU table to enable populating the OFFER LU table based on data from the SUBSCRIBER LU table.

When an LU table has two populations, a second Table Population can extract data from the same LU table. For example, the ADDRESS LU table has two Table Populations:

  • Population 1 extracts data from the CRM DB.
  • Population 2 extracts data from the ADDRESS LU table that has been inserted by Population 1.

Click for more information about Creating Table Population Objects.

How Do I Create a New Table Population From a DB Query?

  1. Go to Project Tree > Logical Units > [LU Name].
  2. Click Tables, right click [Table Name] > New Table Population to open the working area for creating the mapping.
  3. Click the Objects tab in the right panel of the Table Population working area.
  4. Click Databases to display the list of interfaces defined in the project or a built-in Fabric interface.
  5. Double-click on the required table name or drag it into the working area.
  6. Click Create as DB Query to create the DB query source object in the working area.
  7. Optional: use the Edit Query option to edit the input query via the Query Builder, for example, to choose specific columns or conditions in SQL statements. Do either:
    • Click the source object, then go to the Properties tab > Edit Query in the right panel of the working area.
    • Double click the source object.
  8. To connect the source object to the target LU table, right click the DB Query object and either:
    • Click Auto Connect to Table.
    • Connect the fields manually.

How Do I Create a New Table Population From a Root Function?

  1. Go to Project Tree > Logical Units > [LU Name].
  2. Click Tables, right click [Table Name] > New Table Population to open the working area for creating the mapping.
  3. Click the Objects tab in the right panel of the Table Population working area.
  4. Click Root Functions and do either:
    • Select an existing Root function and drag it into the working area.
    • Click Create New Root Function.
  5. Right click the source object and do either:
    • Check Auto Connect to Table.
    • Connect the fields manually.

Previous