DSXchange

Is it helpful to turn off the job monitor to increase performance and reduce overhead ?

Thanks in advance

Thanks to both for your valuable suggestion. Let me elaborate my sequence design. I have 2 jobs to run simultaneously in the seq, each job updates the same table for different database instance ($ServId1 & $ServerId2). Before running these jobs we have a nested condition stage to check whether s...

Thanks for the reply Craig.

But the issue is I coudn't find where exactly its getting overridden and it is also set as $PROJDEF in job properties. Is there any function or option to unset the value for the env variable ?

In one of the sequencer I see we are using nested condition stage with condition $ServId1='' then execute echo command in execute command stage(to write into a log file that $ServId1 doesn't exist) otherwise run the following job. My question is $ServId1 is an environment variable with a default val...

Make sure that any change in the meta data should reflect in the container.

Are you using join stage in your job ? If yes then try changing it to lookup stage.

I think 12 minutes for 2 million rows with i dont knw how many columns but look reasonable. Check the indexing on your source and target tables.

I cant understand your requirement, can you elaborate it. You need to specify what columns belong to what table and what is the business logic in you transformations.

I would suggest you to try releasing the job from DS administrator if you are not able to do it from DS director. Go to DS Administrator, select the project, click on command button, give command LIST.READU ALL, look for the user and inode for that particular locked process, give command UNLOCK USER...

Try killing the job from command line.

There is a good explanation for your question in the documentation provided by Data Stage.

Hi, In the transformer stage properties when I click the help tab it opens the help window but i cannot find the details regarding parallel function, strings etc which i used to get in version 7.5.x. Did they remove those information in version 8.0 or am I looking in the wrong place ? Thanks in Adva...

Make sure the meta data and keys in the files you are passing through CDC matches each other.

If IsNull(trim(priorSnapshot2.PRVDR_GRP)) then '' else trim(priorSnapshot2.PRVDR_GRP)

in the column derivation works too.

If your RCP is disabled then you need to map the new columns from source till target. What is your job design ?