DSXchange

@Chulett, For the first question regarding increasing number of nodes to 2 , I attempted a test run main_program: Startup time, 1:38; production run time, 8:42. And regarding partitioning Its a hash partition on sort stages after the oracle connector extract then down in the flow I try maintain the ...

Hi, I am debugging one of the job running in single node (DS 11.5 / windows server) that is taking "about 5 minutes of production run time " .my goal is to identify bottlenecks and performance tuning of job to make sure it runs efficiently (lesser time). Job design contains reading oracle ...

Thank you craig

Hi Everyone, We are currently using Data loader script for loading into Salesforce (Upsert)and script takes an average of 5 minutes to finish the upsert operation of 10 objects . We are replacing the Data loader scripts with SF pack load job for each object loading ,each job taking an average elapse...

Hi All, I have a few time stamp fields in transformer stage I am defaulting to Blanks ('') because I do not have source data but these fields are needed as an input for funnel operation . Also I am converting few timestamp fields to string (vachar) using below derivation If IsNull(lnk_records.DATE) ...

Hi, My requirement is If there are NULLs present in source (Oracle table) for decimal fields then I need to convert them into Blanks in target ( Flat file ). oracle (source) > Leftouter Join >XFM > DataSet >cdc >Flatfile Transformer derivation ,I wrote If IsNull(lnk_col1) Then '' Else lnk_col1 After...

Oh I see ..I thought there may a other option than backup .. I do take the backups but that job was just brand new and issue happened soon after creation

Anyways Thank you everyone for the contribution in this discussion .I am closing the post .

I made a new job with some sample stages ..they are present and can see on the designer and it ran fine .

Thanks.

No worries ..May be Its because I did not emphasize enough on one job during my replies .I also checked the option of recover the job but DS Admin says there is no recover in datastage currently we have .(Not sure does it meant in DS itself OR in our project we have to setup for this).That leeds nex...

Paul,
Yes ..Job is corrupted and "CopyOf" Job did not work either.We haven't look much into local install of the client code as the issue started while I am connected via VPN. and rest all jobs were fine.

Thank you for the valuable suggestions .

So this went from an "only me" issue to everyone having the problem? If so that completely changes what kind of advice you'll get. Let us know if your 'alternate VPN connection' solves anything for you... Yes ..Its only with me .I had this below messages very frequently (issue is with via...

Hi PaulVL, Yes ..Its about missing stages on Canvas .Next I opened a job( issue with missing stages) and try to place the stage on the canvas .I got below message and program (designer )got closed there after . Runtime Error! Program:C:\IBM\InformationServerV115\Clients\Classic\dsdesign.exe abnormal...

Tried re-booting also no luck ..very slow response when I open stages and editing the objects .

@PaulVL, Client is installed on the Local Machine And Also I rebooted the PC but still I do not see the Objects .The response time is very slow while I am doing the changes for the objects (during development on canvas) For now ,I am doing re-work for that job :( but want to find out the solution so...

@Chulett,
Its only with me I checked with my DS admin .