DSXchange

ok ..Lets wait for their Reply ..

Thanks for your help ...

Hi Craig,

If what you say is right then I will take Elapsed time , which is total time for job ...

So my equation would be :

No of processed rows for particular link /Elapsed time ...

Hi ,

Elapsed time is the total time for job , I would like to calculate time taken for particular link ..

so the equation would be : No of row for link abc/ time taken to process those rows on abc .

Pl suggest...

Hi , I checked DSlinkinfo , but there is no option for no of rows /sec , following r options ...any input is appreciated ... DSJ_LINKLASTERR The last error message reported from a link. DSJ_LINKNAME Actual name of link. DSJ_LINKROWCOUNT The number of rows that have been passed down a link. DSJ_LINKS...

Thanks a lot..i will check it out

Hi ,

I am collecting statistics of datastage job using datstage macro and share container ..

Is there any way we can capture throughput of particular link i.e rows /sec after its completion..

Please advice ...

Thanks.

Thanks ,


I will try ...

Hi Craig, I have built shared container which runs in every job and collects stats for each job ... I looked into KIMs ETLSTAts jobs , but it looks very complex , I do not have much time to implement ETLSTATs as need to provide STATS result soon .. What is the methos to calculate in after job routin...

Hi , I used it in transformer which loads target table ...I want to capture run statistics of job , i am using datastage macro functions to calculate start time, end time , elapsed time..But i am getting elapsed time zero ... How can I use it in after routine and update the STAT table . Please sugge...

Hi ,


When I am using DSGetJobInfo(DSJ.ME, DSJ.JOBELAPSED) in transformer in the job ...It is giving 0 AS result ..

I tried to search , it says its bug and can be fixed with patch fp1 ..We have installed that patch ...still i am getting 0 as return value ...

Anybody has any clue ..

Thanks..

Hi ,

It is giving out of range error ...I will post exact error tomorrow ...

Thanks for the reply...

Hi ,

I am loading data from SQL Server 2008 to oracle ...One of the datatype is Nvarchar ...it is giving problem while loading into datastage ..I am using DRS stage for sql server ...

Please suggest ..

Thanks,

Thanks a lot... I could not read the entire message as i am not the premium member , but i saved the .txt to .csv and it worked fine ... The date is coming in '9/14/2009 3:16:16 AM' , I have ' If IsNull(trim(tdCall_From.Created_Date)) then @null else oconv(iconv(trim(tdCall_From.Created_Date),"...

Hi , I am converting txt files to csv .. I open txt file into excel 2007 , 'comma' is used as delimiter and save it as .csv. When I open it into seq stage , I see verticle line at the end of last column , and square in the database . I tried coping the file and pasting as special values by selecting...

I think the error is due to other data element which has etra double quotes ...

Thanks..