DSXchange

Have you thought of using lookup instead of join? the lookup dataset (4500) will be held in the memory and the 95mil need not be sorted. Just a thought.

As Ray mentioned there is no document available for this. This tunning is purely dependent on the volume of data and hardware / resource available. In your scenario (ie. the input being 8Mil+ and Lookup being 1+ mil approx) you are better off using lookup. Some thing you have to look into are how mu...

We had the similar issue after installing 7.5.2 in windows 2003 server. This issue was resolved after the administrator ran the sys prep (For more details on system prep look into microsoft website).

So this may be something to do with the security and and the build.

hi sir, what i mean is in join stage we can combine two or more data sets with a common key column. merge stage also does the same thing with the sorted input data sets. where as the lookup also checks the primary data with the reference data sets and combines the data sets.suppose i want to combin...

Figured out how to perform this Install the MQ-Server and perfor the following step. Back up mqm.dll Re-name MQ client lib (mqic32.dll) to mqm.dll (the name of the server lib) and it works, reads from Remote Queue writes to Remote Queue. Thanks Vijay Team, Our client have the following environment M...

Team, Our client have the following environment MQ - Server - Unix DataStage Server 7.5x2 - Windows 2003 Local MQ-Manager (Windows 2003 same box as DSEE 7.5x2) The requirement is to get and put the messages into the Remote Queue (MQ-Server in Unix). I created the local Queue manager and local Queue....