SAP HANA has six types of Join methods available with it. Inner Join: It selects the set of records matching in both the table.

  • Left Outer Join: This Join selects the complete set of records from the first table while matching a record from the second table if available.
  • Right Outer Join: It works opposite to Left Outer Join. It selects the complete set of records from the second table while matching a record from the first table if available.
  • Full Outer Join: This Join selects all the records available from both the table.
  • Referential Join: Works with the same principle as the Inner Join by confirming a maintained referential entity maintained between the two tables.
  • Text Join: It is used to select language specific specifications.

Acquire guaranteed interview success with these advance SAP HANA interview questions.

Suggest An Answer

No suggestions avaliable!