Linking In Enrichment

Hi @sanjana12 ,

Define a collection: When you create a link between temporary workflow table and database table, this type of link lets you define a link with a 1-N cardinality between the tables. Example, 1 temp data may have multiple records in target database schema.

Define a link whose target is still available: When you create a link between temporary workflow table and database table, this type of link lets you define a link with a 1-1 cardinality between tables. Example, 1 temp data must have one record in target database schema.

Define a link whose target does not necessarily exist in the base: When you create a link between temporary workflow table and database table, this type of link lets you define a link with a 0-1 cardinality between tables. The join condition must be defined by 0 or 1 (max.) record in the target table. Example, 1 temp data May have one record in target database schema or No records in target schema.

Define a link by searching for a reference among several options: this type of link defines a reconciliation towards a unique record. Adobe Campaign creates a link to a target table by adding a foreign key in the target table for storing a reference to the unique record. Example of this type link is explained in detail in this document.