tag:blogger.com,1999:blog-4527276399966185267.post3840299178891165123..comments2024-03-06T20:16:30.599-08:00Comments on Diethard Steiner on Business Intelligence: PDI: Full Outer JoinsAnonymoushttp://www.blogger.com/profile/05683544764949933581noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4527276399966185267.post-31065102501773614742013-11-30T07:43:15.815-08:002013-11-30T07:43:15.815-08:00Yes, with the Stream lookup the data keeps on flow...Yes, with the Stream lookup the data keeps on flowing in your main stream and retrieves the lookup data on the go, whereas with the merge join step, all the data has to first arrive there, only then the join will be performed. The stream lookup is more suitable for a smaller lookup dataset, as the lookup dayta will be cached.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-27996046476222387392013-11-29T09:06:29.176-08:002013-11-29T09:06:29.176-08:00is there any advantages / disadvantages in using S...is there any advantages / disadvantages in using Stream lookup step instead of merge join step ?Siby Abin..https://www.blogger.com/profile/17562269648453198644noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-14890755711850399042011-10-10T05:15:11.168-07:002011-10-10T05:15:11.168-07:00You are welcome! Good to hear that the article cou...You are welcome! Good to hear that the article could help you!Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-30818581005950414722011-10-10T04:31:35.926-07:002011-10-10T04:31:35.926-07:00I'm looking for this, it works for me,..thank ...I'm looking for this, it works for me,..thank you so muchAnonymousnoreply@blogger.com