Hi For question 2 match merging is like full join . In that case we should compare full join using proc sql full join right? But why do we compare using select *from a,b. Correct me if I understood in wrong way.
Hi, You are right. Thanks for spoting this. Should use full join however in full join also first product will be Cartesian product and then query will be optimized as per the join condition.
Interview perspective very helpfull information... please upload some more videos 🙂
Thank you, I will keep uploading.
Sir thank you, your videos are very helpful and please keep on making videos.
Glad to know that you liked it.
Nice explation
Thank you sir
Great explanation
Sir ur videos r very helpful
Glad to hear that.
Nive video
Waiting for other videos on interview prospective
👏🏼
Hi For question 2 match merging is like full join . In that case we should compare full join using proc sql full join right? But why do we compare using select *from a,b.
Correct me if I understood in wrong way.
Hi, You are right. Thanks for spoting this. Should use full join however in full join also first product will be Cartesian product and then query will be optimized as per the join condition.