Enrichment Activity

Avatar

Avatar

jael39132526

Avatar

jael39132526

jael39132526

31-07-2018

The Enrichment activity allows four links:

Picture1.png

In the fourth option (a link):

Picture2.png

Link definition: Allows the selection of the type of link and the target of the link. Link type includes:

  1. Define a collection (1-N relationship)
  2. Define a link whose target is always available (1-1 relationship). The join conditions must be defined by a single record in the target table.
  3. Define a link whose target may not exist in the database (0-1 relationship).
  4. Define a link by searching for a reference among several options (1-1 or 1-N relationship).

Question:

Does each link definition establish a SQL right join from the filtering dimension (table) to the target table?

Or, does it establish a SQL right join except the third option:

"3. Define a link whose target may not exist in the database (0-1 relationship)). The join condition must be defined by 0 or 1 (max.) record in the target table."

...which sounds like it establishes a left join.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

30-11-2018

Hi Jae,

The relationship when enriching data is explained on this documentation: Enriching data

Hope this helps!

All the best,

Pablo

Answers (0)