i thank you all even now for your responses!
i am fairly new to DS, and i am having issue with a job that checks the existing data in a SQL SERVER 3 table joins. (A, b,c) only one of the table is big sized (A). and there is very small table in NETEZZA (nz). i need to insert/update a field in A by nz. All values in nz need to be upd/ins to A. in order to do that i need to check existance of nz.date field in A.date. i thought look up would be a good choice to do that. Im sure you all know what kind of misery i had by matching date values btwn NZ to SQL server.
my problem is:
because A has some size +joins +converting date field +sql server performance
![Smile :)](./images/smilies/icon_smile.gif)
SO I NEED TO FIND A WAY TO MAKE MY LOOK UP MORE EFFICIENT!
i am open for any ideas.
and i thank you all!