Lookup table and join table - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

You can use lookup and join tables within the same database in the same unidirectional Copy, Replication, or Synchronization request:

A lookup table is a built-in data enhancement method called (LookupDatabaseTable) that takes a source column value, looks up this value in a key column (the lookup table), and returns the value of some other single column from the lookup table.

The join table feature extends table lookup by allowing multiple columns to be retrieved from a secondary join table. When the row is selected from the secondary join table, all the columns in the secondary join table become accessible for use in a secondary target column expression.

No column in the joined table may be referenced in a gate condition where you specify a Boolean expression whose results, if true, allow data transmission of the row based on a valid expression for the column.

Join columns can only be reference in a result expression.