When can you use the referential join in SAP HANA?

In the context of SAP HANA, referential joins are utilized when referential integrity is assured. This means that there is a clear and consistent relationship between tables, ensuring that any foreign key value in the fact table that points to the dimension table corresponds to an actual value in that dimension table. This guarantees that the referential join can reliably combine data from both tables without ambiguity or inconsistency.

The integrity of the data ensures that queries on joined tables will yield meaningful results based on the defined relationships. Therefore, when using a referential join, users can be confident that they are retrieving only those facts that have valid dimensions, avoiding discrepancies in data analysis. This is crucial for accurate reporting and analytics, particularly in environments dealing with large volumes of data.

The other choices do not encapsulate the specific need for referential integrity that is central to the use of referential joins. The focus on matching facts or dimensions, as presented in some other options, does not encompass the broader requirement that referential integrity must be ensured for the join to function correctly and for the results to be valid.