Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.
Correct Answer: D
According to the SAP HANA Developer Guide, a multi join is a join that can be defined only with multi-column join in calculation views. A multi join allows you to join multiple data sources using multiple join conditions. You can specify the join type, the join cardinality, and the join columns for each pair of data sources. A multi join is useful when you need to join data sources that have complex relationships or different granularities. The other options are incorrect, because:
* A dynamic join is a join that can be defined with either single-column join or multi-column join in calculation views. A dynamic join allows you to join two data sources using a join condition that is evaluated at run time based on the user input. You can specify the join type, the join cardinality, and the join columns as parameters or variables.
* A text join is a join that can be defined with either single-column join or multi-column join in calculation views. A text join allows you to join a data source with a text table that contains language-dependent descriptions of the data. You can specify the join type, the join cardinality, and the join columns as well as the language column and the language code.
* A temporal join is a join that can be defined with either single-column join or multi-column join in calculation views. A temporal join allows you to join a data source with a history table that contains time-dependent versions of the data. You can specify the join type, the join cardinality, and the join columns as well as the validity columns and the validity period.
References: SAP HANA Developer Guide, Chapter 6, Section 6.4.2, page 2111.