SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
Hadoop App
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Hadoop App
Stay Connected
Search Topics
Topic Index
SAP HANA Modeling
Spatial Processing
Predictive Analysis

Temporal Join

So far we learnt about Different types of Joins in SAP HANA and Text Join
In this article we will learn about a temporal joins in HANA.

A temporal join indicates the time interval mapping between the master data and the transaction data for which you want to fetch the records.

You create a temporal join using the temporal column that specifies the time interval with the start and the end date. The result set is fetched based on the time interval mapped using the temporal column.
A record is only included in the results set if the time interval lies within the valid time interval. A time interval is assigned to each record in the results set. The records are valid for the duration of the interval to which they are assigned.
You use temporal conditions to indicate whether to include or exclude the value of the FROM and TO date fields while executing the join condition.

In the logical join, you can create a temporal join between the date field of the fact table to an interval (to and from) field of the attribute view. The temporal join must start from the fact table such that the single column must be in the fact table and, the to and from columns must be in the table that is directly joined to the fact table. The join type must be Referential. The supported data types are: timestamp, date, and integer.
  1. In the New Join window, create a referential or an inner join between the attribute of the fact table and the attribute view.
  2. In the Properties panel or from the New Join window, select:
    1. The Temporal Column that indicates the single time column in the fact table.
    2. The From Column and the To Column to specify the time interval from the attribute view.
    3. The Temporal Condition which would be considered while executing the join.

Support us by sharing this article.

Explore More
Close X
Close X

2 thoughts on “SAP HANA Temporal Joins

  1. Raghavendra says:

    Dear Admin,

    Thank you for providing valuable information on Temporal join.

    Could you please give one example where we would use this join?


Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 :, All rights reserved.  Privacy Policy