Which join types Can you use in a CompositeProvider? (3)

Question

Options

• AReferential join
• BFull Outer join
• CText join
• DHierarchy join
• EInner join

• A
  93% (26)
• C
  4% (1)
• D
  4% (1)

Explanation

In SAP BW's CompositeProvider, the three supported join types are Referential (A), Full Outer (B), and Inner (E). These cover the standard relational join patterns needed to combine InfoProviders: Inner join returns only matching records, Full Outer join returns all records from both sides (with NULLs for non-matches), and Referential join works like a left outer join but assumes referential integrity - meaning the system trusts that all keys from the left side exist on the right, enabling query optimizations.

Text join (C) is not a join type at all in this context - it's a distractor referencing how text/description fields are associated with characteristics via text tables, which is a separate concept. Hierarchy join (D) is similarly not a valid CompositeProvider join type - hierarchies in BW are handled through hierarchy InfoObjects and navigation attributes, not as a join category.

Memory tip: Think "RFI - Real Flex Inside" - Referential, Full Outer, Inner - the three joins a CompositeProvider actually uses to connect data. If an answer sounds like a BW metadata concept (text, hierarchy) rather than a SQL-style join, it's a distractor.

No community discussion yet for this question.