can we join PPI table to NON PPI table

Database
Enthusiast

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
Enthusiast

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

Enthusiast

Re: can we join PPI table to NON PPI table

Thank you Raja.

Yuvana