A Join clause combines records from two or more tables /view in a database.
SAP HANA supports following types of join.
SAP HANA Studio Download and Install, Steps to Download Free SAP HANA Studio with the details of installation paths. HANA Studio is used for developing artifacts in a HANA server. It allows technical operators to handle the SAP HANA database, to make and accomplish user approvals, to create innovative models of data or change current models of. The SAP HANA studio is a collection of applications for SAP HANA. It enables technical users to manage the SAP HANA database, to create and manage user authorizations, and to create new or modify existing models of data in the SAP HANA database.
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Referential Join
- Text Join
- The INNER JOIN selects the set of records that match in both the Tables.
Where to use :
Inner join should be used if referential integrity is ensured.
Inner Join is much faster that Outer Join thus is the preferred solution if possible from semantically perspective
Attribute View : Inner Joins can be used to join different master data tables to a joint dimension
Analytical Views: Inner Joins can be used if referential integrity cannot be ensured
- The Left Outer Join selects the complete set of records from first table (CUSTOMER), with the matching records (where available) in second table (SALES_ORDER). If there is no match, the right side will contain null.
- The Right Outer Join selects the complete set of records from second table (SALES_ORDER), with the matching records (where available) in first table (CUSTOMER). If there is no match, the left side will contain null.
- The FULL OUTER JOIN keyword selects all rows from the left table (table1) and from the right table (table2).
The FULL OUTER JOIN keyword combines the result of both LEFT OUTER and RIGHT OUTER joins.
- Referential Join is semantically an inner join that assume that referential integrity is given.
Note: Referential integrity is the property of database which ensures that each foreign key value in a table exists as a primary key in the referenced table.
Referential join is performance wise better than inner join, but only be used when you are sure that referential integrity is maintained.
Sap Hana Studio Download
- Text Join is used in order to get language-specific data.
You have a product table that contains product IDs without descriptions and you have a text table for products that contains language-specific descriptions for each product. You can create a text join between the two tables to get the language-specific details. In a text join, the right table should be the text table and it is mandatory to specify the Language Column.