DSXchange

Hi,

My requirment is to replicate the logic of oracle user defined function into datastage and my database is netezza which does not support these types of user defined functions. So for that i have prepared one parallel job for achieving the same thing with the help of DS job but because of the business logic i had to use one particular dataset 7 times (As lookup) in that single job.

So i just wanted to know whether referring one dataset in this way will make any performance impact ?

I forgot to mention the number of records, the job is processing:

The input stream contains around 3-4 millions of data where as the lookup dataset contains around 0.1 million of data.

use copy stage between reference source and lookup stage and have 7 output links from copy stage for lookup purpose.

Thanks for reminding me the COPY stage.