Thursday, March 23, 2006
There is that great task in BI studio in SQL 2005, I didn’t need to use it before, but when I needed it, Ijat 3al waja3 !
What it does is simply joining two data sets (I think you can join more than two, but I didn’t try it); you choose which one is the left side data set, you choose the type of join and the join keys, all that is perfect:)
But what really broke my heart is that there’s an additional Bonbon:). Look at the picture, there is a SWAP button:), in case you changed your mind and wanted to make the right side data set left and vise versa , oooooooooooooooohhhh isn’t that sweet!
I wonder what my penguin friends think about it :P