DSXchange

Hi, We had a service that was processing a request in 500 ms - 1 second. around 20,000 requests were processed in 1.5 hours. The service was calling a datastage job. Recently the job was split to two jobs. Two new services are created to call these new jobs. A wrapper job is created two call these t...

It will not effect the performance of the DB stage but will effect the performance of job as the partitions are there on all 10 input links to the funnel.

Please share how you resolved the problem.

This is because the two corrspondences are not getting sorted properly i.e. the first two records are sorted with the recipientBpId in the order of 1000000047 and 1000000045. The next two records belonging to other role are getting sorted in the order of 1000000045 and 1000000047. This i think is th...

Thanks ernie, i have created the first xml output stage with correspondence as repeating element, the second xml output stage with accountRoleToAccount as the repeating element. the issue is this after the correspondence xnm output stage it is creating 2 correspondence records , due to this: Peek_43...

As you can see a single XML is getting broken to two. The repeating eleamns are <accountRoleToAccount> and <correspondence>.The verison being used is 8.1. so i have to use multiple XML stagews to create the xml back from tabular data. The reason it is creating the output in the way it is , because t...

i have to read the data , change to tabular form and create the xml back: the xml out put lloks like this: sapAccount actionCode=" "> <accountRoleToAccount actionCode=" "> <role>ZPROP0</role> <validFromTo> <validFromDate>2011-03-30</validFromDate> <validToDate>9999-12-31</validTo...

Hi, I have an issue with an XML output creation: The input is like this: <sapAccount> - <accountRoleToAccount> <role>ZPROP0</role> - <validFromTo> <validFromDate>2011-03-30</validFromDate> <validToDate>9999-12-31</validToDate> </validFromTo> </accountRoleToAccount> - <accountRoleToAccount> <role>BCA...

Keep the delimiter to tab instead of comma and if the file is crated in UNIX, use unix new line format when reading the file. Similarly DOS format applies in windows environmnet

Can it be because of a different config file?

As mentioned by Craig and Ray, the best way is that check the metadata of seq file in the stage. Also add reject link to the stage to capture any unruly data. You can send the rejcts to the owners of file to correct it.

Read the date field from source file as a varchar field. Use a stringtodate function in a transformer stage to change it to the required format before loading it to database.

Server job exposed as web service failing with error: Link_Collector_13.InvalidXMLError: ds_ipcflush() - timeout waiting for mutex After further investigation i found that this error occured due to presence of stored procedure stage in the job. Since the job is exposed as always running i.e. minimum...

Yes.

Since the actual column in the sql table does not have a decimal, import the field as integer instead of decimal (which is the default for all numeric datatypes). No need to use covert function.