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