DSXchange

Hi, I have faced an issue with stages/links getting disappeared automatically .But the job in finished state .When I tried to opened the designer I got below message MycreateObject:Internal error-trying to create object with empty class I am able to re-run the job from Director ..But can't see any o...

@chulett ,Thank you for the response . The issue is happening randomly ..This morning job runs were successful but when I try to re-run now they are getting struck at point (file deletion script ).. No action there after: STATUS REPORT FOR JOB: jb_rename_datasets..Job status=1 (Finished OK) SEQ_Load...

Hi, In our project ,We are using Execute Command Activity stage to call vb scripts (to perform various file movement activities like deletion,rename and append filename ) But Some times the scripts are running for ever .Unfortunately there isn't much logging available I would like to know if there a...

Hi ,

I am researching the options for usage of credit lookup service through datastage (ex:experian, equifax and transunion ) for credit rating services

Please post the information if anyone using in their environment or have an idea about this ?


Thanks

Hi PaulVL,

When I connected through Remote desktop I was able to login to web console
Under the Administration tab >Domain Management >Engine Credentials >select IS Engine (Open my credentials --default I see dsadm username)

I will co-ordinate with dsadmin for more details

Thanks

Where to check this information ? When I click "open web console "It says Your connection is not private. All that I am using a HOST name and username, password for the log on.

Thanks ..

Hi, Our Environment is IIS DataStage 11.5 on Windows.I am able to login to Information Server When I try to login to client components (designer,director,administrator) it is giving the following error message after several attempts I was able to login but this is happening frequently failure to aut...

Hi, I am using teradata table as my target ..I need to insert the date fields in the format "mm/dd/yyyy" dataset ----->xfm -->Teradata While writing to dataset I used varchar and assigned "mm/dd/yyyy"-- I am able to write data but I need to load the date fields in date format Wha...

Thank you all for the responses and sorry for the confusion. I need to look for the First two characters from the string (ex:CT --Central Time) and have Derivation as "(UTC-06:00) Central Time (US & Canada)" in my target field. stagevariable :- svTimeZoneCD --Left(Timezone_Code,2) Outp...

Hi, I need to derive timezone(s) from the input field ...sample data below Timezone_Code CTIL ETFL MTAZ PTCA Output (UTC-06:00) Central Time (US & Canada) (UTC-05:00) Eastern Time (US & Canada) (UTC-07:00) Mountain Time (US & Canada) (UTC-08:00) Pacific Time (US & Canada) Is there an...

Hi , I have the requirement for a particular division ,generate group numbers for the stores based on the employee count threshold limit (<=4800 )per each group.Same store should not be present in multiple groups.(ex:store 1286 is present in multiple groups ..jumped group 1 to group 2 instead have g...

@chulett,

Nice idea ..worked for me

Hi, I have the following requirement that I am using transformer loop concept Input sno|col1|col2 1 a;b 2 c e;f 3 d 4 g;h Expected ouput sno|col1|col2 1 a 1 b 3 d 2 c e 2 c f 4 g 4 h Job Design seq file -->xfm -->seq file (output) Transformer logic --Stage Variable 'svcol1Delim' Dcount(lnkInput.col1...

Thanks ray ..this is what I am expecting will check once we have 11.5 available

@ray, I overlooked while posting in the forum its the same in both functions as per my current code . ';' I am still figuring out the way to pass more than one field loop variables .But had some progress on the (Dep_DSC_INDICATOR) file splitting through Sequence loop activity . Approach I followed D...