All Forums Database
yuvana 7 posts Joined 09/14
17 Sep 2014
can we join PPI table to NON PPI table

can we join PPI table to NON PPI table?, What is the behavioural of the table?, which Join we have to use to do this? 
Can any one explain this?

Tags:
Raja_KT 1246 posts Joined 07/09
21 Sep 2014

Yes, it can. It can give rise  to making a PPI-to-spool File join.  You can create tables, insert data and check the explain.
You may have heard about single/sliding window merge join
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1142_111A/ch03.125.085.html
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1142_111A/ch03.125.087.html

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

yuvana 7 posts Joined 09/14
14 Oct 2014

Thank you Raja.
 
Yuvana

You must sign in to leave a comment.