February 19, 2015 at 1:16 pm
Hey, I have a project where I am doing a one time push of data into a DW. After developing 2 packages (one from source to Raw and the other from Raw to Stage), it was decided that the push to the Data Warehouse would be through a SQL Script. I have been given an example of a package that pushes similar data to the Data Warehouse. As I am combing through the package and I come to Lookups I want to use inner joins. I know the Lookup transform uses equi-join but Im not sure what the difference is between equi-join and inner join for a matches only output. Im not thinking there is a difference, am I wrong?
February 19, 2015 at 1:56 pm
You are not wrong, or, you are right 🙂
Steve.
February 20, 2015 at 9:31 am
stevefromOZ (2/19/2015)
You are not wrong, or, you are right 🙂
Hang on a minute... you need to bear in mind that a Lookup task will only return the first occurrence of a match whereas an INNER JOIN will return all occurrences.
Regards
Lempster
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply