Skip to Content
avatar image
Former Member

HANA - SQL Script - Basics

Hi All

1.   There are two objects in HANA Table and Table Type can any body explain the difference between them

2. Also the difference between Inner Join and Referential Join in the context of attribute views and analytical views.

Thanks

Santosh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 26, 2012 at 05:30 AM

    Hello Santosh,

    Some points from my side:

    1. While creating table, ROW Store, Column Store and Table type are the option.

    For modelling the table should be Column Store type.

    For more explanation please find the below link:

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70d16119-ad21-2e10-de8b-eaaedf86b9cd?QuickLink=events&overridelayout=true&50603304707848

    Table types are used to define parameters for a procedure.

    2. Please find the link below for difference between Inner and referential join.
    https://www.experiencesaphana.com/blogs/datamart/2011/10/17/sql-join-union--what-you-ever-wanted-to-know1

    Hope it is useful for you.

    Regards,Neha

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Neha Singla

      Hello Neha,

      Does it mean, if i have any filter on my right table, then referential join doesn't work so it will fetch "0" records? is it?

      Can you be more clear on this line?

      Regards,

      Krishna

  • avatar image
    Former Member
    Apr 29, 2013 at 11:37 AM

    referential joins are to ensure the data integrity during insertion of data. if we have a referential join between dimension table customer and fact table sales on customer id field, then this means, we cannot insert any record with customer id that is not in customer table. these constraints help to maintain the data integrity.

    Add comment
    10|10000 characters needed characters exceeded