You need to combine attributes data (left table) and the datas language-dependent texts (right table) using a text join. You want to restrict the result set to the logon language. What do you need…

Question

Options

• AThe logon language the left table
• BThe join cardinality between both tables
• CThe language column in the right table
• DThe language column in the left table

• A
  3% (1)
• B
  3% (1)
• C
  89% (31)
• D
  6% (2)

Explanation

Option C is correct because in a text join, language-dependent texts are stored in the right (text) table, which contains a dedicated language column (e.g., SPRAS or LANGU in SAP systems). To restrict the result to the logon language, you must select and filter on that language column in the right table, setting it equal to the current logon language.

Why the distractors are wrong:

• A is wrong because the logon language itself is not a column in the left (attributes) table - the left table holds language-independent attribute data.
• B is wrong because join cardinality (1:1, 1:N, etc.) describes the relationship between tables but has nothing to do with filtering by language.
• D is wrong because the left (attributes) table typically does not contain a language column at all - language dependency lives in the right (text) table.

Memory tip: "Text lives on the right, language lives with the text." The right table holds the translated texts, so it owns the language column - filter there to get only the logon language's rows.

No community discussion yet for this question.