Which link type returns what data?

You want to blend data in a story from two models (see graphic below). Model 1 is the primary model.

Which link type returns what data Primary All Intersection

Which link type returns what data?
A . Primary
B . All
C . Intersection

Answer: C

Explanation:

The link type determines how the data from the primary and secondary models are blended in a story. There are three link types: Primary, All, and Intersection1.

Primary: Only the data from the primary model that matches the data from the secondary model is displayed. This is equivalent to an inner join in SQL.

All: All the data from both models is displayed, regardless of whether they match or not. This is equivalent to a full outer join in SQL.

Intersection: Only the data that exists in both models is displayed. This is equivalent to an intersection in set theory.

In this case, the link type that returns what data is Intersection, because it only shows the data that is common to both models, such as Customer A and Customer B. Customer C and Customer D are excluded because they do not exist in both models.

Reference: 1: Blending Data from Multiple Models

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments