Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Enrichment Activity

jael39132526
Level 2
Level 2

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.

1 Accepted Solution
pablo_rosero1
Correct answer by
Level 10
Level 10

Hi Jae,

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

Hope this helps!

All the best,

Pablo

View solution in original post

1 Reply
pablo_rosero1
Correct answer by
Level 10
Level 10

Hi Jae,

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

Hope this helps!

All the best,

Pablo

View solution in original post