SAP-HANA
SAP HANA Tutorial: Create Trigger
What is Trigger? A trigger is also a stored procedure that automatically executes when an event...
Join in SAP HANA is used to Join table and information view and select values as per the requirement.
There are following types of Join method to Join SAP HANA tables –
Join Type | Uses | Comment |
INNER | Inner Join selects the set of records that match in both the table. | |
LEFT OUTER JOIN | Left Outer Join selects the complete set of records from the first table, with a matching record from the second table (If Available). | If no match from the second table, Null value select from the second table. |
RIGHT OUTER JOIN | Right Outer Join selects the complete set of records from the second table, with matching record from the first table (If Available). | If no match from the first table, Null value select from the first table. |
FULL OUTER JOIN | Full Outer Join selects all records from both the table. | |
REFERENTIAL JOIN | It is same as inner join by assuming that referential entity is maintained between the two tables. | It is available for only attribute view and analytic view. |
TEXT JOIN | Text Join are used to select language specific specification | For Getting Description of the column it is used. |
What is Trigger? A trigger is also a stored procedure that automatically executes when an event...
What is SAP HANA DXC? SAP HANA DXC is batch driven data replication technique i.e. it can execute...
What is DATA Provisioning? DATA Provisioning is a process of creating, preparing, and enabling a network...
SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE...
What is Sap HANA? SAP HANA is the latest, in-memory database, and platform which can be deployed...
$20.20 $9.99 for today 4.6 (120 ratings) Key Highlights of SAP HANA Tutorial PDF 253+ pages eBook...