Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED
Linking In Enrichment
1 Accepted Solution
Correct answer by
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.
Correct answer by
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.
