DSXchange

I am trying to design a Parallel job that sends couple of columns from a flat file into a webservice using a webservice transformer and the response from webservice needs to send to a flat file. While trying to import the metadata using the wsdl file given by webservice team, I am getting this error...

Hi Srinivs,

I am getting the same error. How you got this error fixed? i am doing exactly same thing that you are doing... Please let me know how you got this error fixed.

chulett wrote:I don't think your firewalls would cause any of this. Another question - what Update Action are you using in the stage?

The problem is not with one job, all jobs are having same problem.Some jobs are insert only, some are Update and Insert,some are clear and insert,some are update only.

How much greater than 1 are you using? And what is the Transaction Size you are using? :? We tried different array size and Transction size, still we are getting same error.....Whatever Transaction size we put the array size has to be 1, if we put even 10 in the array size it fails.....One more thi...

gateleys wrote:

chowdary wrote:We are using DRS stages for reading and loading the data.

What happens when you use the OCI stage instead of DRS?

gateleys

We are getting same error with OCI Stage

Hi all, We are facing a strange problem. All our jobs are aborting when we put array size greater than 1. If we put Array size as 1 jobs are running fine but performance is really bad like 40-50 rows/sec. If we put Array size greater than job will start processing data like 300-400 rows/sec and abor...

People, I am getting this weird warnings wile dumping the data from the Oracle table into XML file 1)Abnormal termination of stage JobName..StageName detected 2)DataStage Job 6531 Phantom 12293 jobnotify: Unknown error 906 [12305] DSD.StageRun JobName. JobName.StageName 1 0/0/1 - terminated. DataSta...

People, I having problem in writing duplicate records in a an XML File. I am reading data from an oracle data base, in that there are two records like Col1 Col2 Col3 Col4 060010 Drvr/Spy 2 6 060011 Drvr/Spy 2 6 while i am writing into a XML file the output is in the format <Col1>060010</Col1> <Col1>...

People, I have an email field which i am extracting from a table and writing into a flat file. for some rows the email is in invalid format (example king~123@test.com,king%123@test.com etc). so i want to write the data in to the flat file whihc has valid email like the filed must have characters a-z...

Thank you very much, It's working.

chulett wrote:Outputs / Properties / Wildcard. That controls what file(s) are read. If you don't use a wildcard pattern there but use a 'normal' filename it will just read that file in. You can use a parameter there in either case.

I am reading using the Folder Stage, Where i can parametrize the filename in the folder stage, i know we can parametrize the path name of the files but i don't know how to parametrize the file name. please help me in this one. Thanks Chowdary How are you 'reading' it? That stage should support param...

People,

I have a job which reads data from XML file and dunp into a Oracle Table,
Is there any way that i can parametize the XML file name?

Thanks Usha, i will ask them to the give the XSD's Once again thanks for the reply Thanks Chowdary Hi Chowdary, sorry for the late reply, jus got to see ur msg, the XSDs are given by the vendor only, and these XSDs can be sitting anywhere on our desktop, and while importing the metadata, load - XML ...

Hi Usha, Thanks for the reply, i have a question regarding the metadata, how i can get the xsd? For us some third party vendor will deliver will these XML files which we need to put in our DWH. All the gave is a word document which has Coloumn defnitions in a Tabular format in that word document. So...

Chulett, Thanks for the input, i tried that one, it works but it has small problem, problem is for some reason the upper stream which pulls data from Table A and sumps into XML file failed in some 1000 th row, by that time the Audit table is geeting updated and it is not getting roll back. i don't k...