Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Apr 9, 2024 7:15 AM UTC

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.

~  ParthaSarathy S

5 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Apr 9, 2024 7:15 AM UTC

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.

Translate
~  ParthaSarathy S
Sanjana12Author
Level 6
Apr 9, 2024 4:35 PM UTC

Regarding the last link, by target table do you mean the temp worktable?

Translate
ParthaSarathy
Community Advisor
Community Advisor
Apr 10, 2024 7:32 AM UTC

@sanjana12 , Target table is the one which you are going to link with workflow's temp table.

 

Translate
~  ParthaSarathy S