Explain the different types of JOINS in SAP HANA?

1.	Explain the different types of JOINS in SAP HANA?
Answer» 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.

Answer»

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.

Discussion