DSXchange

Am using XML 8.5 stage to read an XML file, when there are values in the XML file the stage works fine and gives the desired result. But when we are not giving any tag for that particular field in the input XML file the output is derived as 1.00 rather than a null. Have anyone encountered this issue...

Am expecting about the real time style jobs usage only.

am also exactly trying to understand this WAVES concept. Can anyone help to understand it ?

Thats the requirement of the client to migrate from Informatica to DS

Hi all,

We are planning to migrate jobs from Informatica 8.6.1 to Datastage 8.6.1. Can you pls provide the best way to achieve this migration and also the steps if you have encountered these kind of migration.

Thanks for your time,

Regards,
Senthil

Seems like the sequence is corrupted, try deleting the old sequence and then move it as if you are moving newly

then dsadm is the user on an Unix account, so its just like an unix account and the password can be changed as stated with the passwd command

More means it takes greater then 6 hrs, and Ok i am now going to try out with Sorting the data based on country as you suggested.

Hi, I have created a match job to compare the address information and blocked on the Country field. Both the input file has country fields. File A has around 79K records and File B has around 30k records, the job is taking more time to run. Can anyone help me out to decrease the time taken? Or shoul...

Hi, i have developed a match job in Quality stage and made a block based on Country for the two input files. The job is running for more then 6 hrs and dint show the completion message, but when i checked in the unix directory for the output files(Match,Clerical,Residual) all are created, am not sur...

Pls suggest me how to write DSSendMail interface routine,

Hi,

Am using Notification stage to send a mail. I need to attach the JobRunTime in the email Body. I tried to use the DSJobStartTime , but its not working.

Is there anyway we can attach the JobRunTime in the email body?

Thanks,
Senthil MP

Hi while trying to insert into a table in the job, am getting the following error. nls_map_buffer_out() - NLS mapping error, row 38434 (approx), This job is tryign to insert values like Na z?bo?? 47 (the '?' are symbols which are converted i.e the special character which are not supported are transf...

Ok Craig, Thanks

Hi, Am facing some issue with performance of the job. The CPU resource on the server on which the target table database(Oracle) resides is not been well utilized by the Datastage job. i.e the Server on which the Database resided is alwasy 60% idle but still the Datastage job is not using the idle re...