Enrichment Activity

Avatar

Avatar
Validate 1
Level 1
jael39132526
Level 1

Likes

2 likes

Total Posts

12 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
jael39132526
Level 1

Likes

2 likes

Total Posts

12 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
jael39132526
Level 1

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
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

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)