DSXchange

Hi,
Have you tried compiling these batch jobs,If u are not able to compile then move the header files(user defined) to the Corresponding location.

Thanks,
Siva.G

My Source & Targets are:Oracle stage.I am using the transaction size as zero.If i change this to 100 0r 1000 what would be the impact to performance? Thanks in advance :) Hi, what is your target? Oracle, Informix, SqlServer...? are you using Plug in or ODBC? in any case, one of the things you sh...

Hi all,

I am receiving the 20 million source records.Using one to one mapping i am loading these source records directly into target.But its taking nearly 45 minutes to load.
How can i increase the performance in this case?
Pls do the needful.

Hi Arnd,

Its just one to one mapping with one lookup(Hash),2 oracle stages (source and target),one link to target.

Thanks,
Siva.G

Hi, We are having a job to update the target table. After updating some records..Its taking infinite time i..e the job is in running status for long time. And we conclude that some session may be running,and due this TM type lock have been ocured,and this job is waiting for that session to commit. A...

Hi, I am in a situation wherein I will be upgrading DataStage from Ver 5.2 to 7.5 and this will involve migrating our entire DataStage code. I have been going through various posts that have been extremely helpful to me thanks to the wonderful forum here. One additional catch is that we would be mig...

Hi,
Iam using simple one to one mapping,After the data get loads in to the target oracle stage.I want to call DSSetUserStatus (value) .Is there any possible to do this.

Thanks,
SivaG

Hi ray,

Thanks,Will u guide me how to Store the Stage variable value in to $UserStatus.

And how to retrive the value from $UserStatus in control job.

Thanks,
SivaG

Hi,
How to return the value of stage variable to a control job.

i.e. I am Storing the count of Duplicates in a stage variable.I want to return this count to the Control job.so that i will log this count in error table.

Thanks,
SivaG

Hi pavithra, This is the routine to reset the job. $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF If DSGetJobInfo(hJob, DSJ.JOBSTATUS) = DSJS.STOPPED or DSGetJobInfo(hJob, DSJ.JOBSTATUS) = DSJS.RUNFAILED or DSGetJobInfo(hJob, DSJ.JOBSTATUS) = DSJS.CRASHED Then Message = "Job is res...