can we join PPI table to NON PPI table

Database
N/A

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 (1)
2 REPLIES

Re: can we join PPI table to NON PPI table

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...

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1142_111A/ch03...

N/A

Re: can we join PPI table to NON PPI table

Thank you Raja.

Yuvana