DSXchange

Well, the WSDL I imported is defining the Response with the Tag : GetPriceResp But I spoke with the guy that wrote the WebServices and WSDL, and he told me that the outcome of the WebService can be also : Fault NO Timeout with : <?xml version=1.0 encoding=UTF-8?> < GetPriceResp xmlns=http://domgen.c...

I found why the Stage is giving a Time out, but don't know if I can resolve this in Datastage. In the Output XML, is expecting the TAG : <GetPriceResp> ... </GetPriceResp> But in some errors , the WebService does not send those TAG, <?xml version="1.0" encoding="utf-8"?> <soapen...

This is the XML Output I should receive ... (from Postman, it is a Soap GUI) <?xml version="1.0" encoding="utf-8"?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Body> <soapenv:Fault> <faultcode>Client</faultcode> <faultstring>An ...

Hello, I'm calling a WebService (using the WebService Transformer). When the WebService return a correct answer, all is ok. But when for example, I change the value of a field in the XML input then the WebService should return me a controled Error, But the WebService is giving me a timeout. If for t...

Hello, I have a parallel job and inside this parallel job I have 2 flows ( 2 sources and 2 target ). Is it possible to do something like ; # First run the first sources db2 and when it finish, run the 2d sources db2. # If not then run the first flow, when it finish, run the 2d flow. Right now I have...

yes thank you, the sort with create key change column worked fine. Another solution was to do a Loop Condition within the Transform. The requirement was if 12 records dup, 11 to error and 1 (max Date) to output. If I had to send the 12 to Error, I think I would do a join after , between the unique k...

Hello,
I 'm reading a file, where the fields , Person Identifier and the Item Identifier, are keys.
I would like to send to Error (for example an output file), all the duplicates records and just keep one (max load date). But don't know really how to do that , could you help me please ?
Thank You -

yes, it did not work the schema file method. If I put in the schema file the delimiter "#" for the fields, this did not work, I had in the output file the "|".

Yes I used the RC then I suppose that with a file connector, using a schema file with RC it does not work.

Thank You -

Hello, I'm trying to use a file connector to write a file but using a schema file and run time column propagation. I need to use a schema file as my output delimiter will depend on the type of file I will generate as output. I've read that for this I have to create a file, with the <output_file_name...

Hello,
We need to create a parallel job that when a query retrieves rows, the job aborts.

Something like a source (with an inside query) then if the query retrieves some records, the job aborts.

thank you -

Hello, In example , We would like to replace any of the folling word1 with empty " in this sentence , change all this wordToChange to the string empty " " in this sentence , change all this -wordToChange- to the string empty " " in this sentence , change all this ?wordToChan...

Hello, I have the same problem as noted here but still don't see the solution. I have to replace in an input string ( for example ADDRESS ) all the salacious words with Empty string for example ADDRESS = "Street Ass" then my output should be ADDRESS = "Street" If I use the erepla...

Hello,
the problem is the "Word" , is not just ONE word , is a list of words
thank you -

Sorry , it is not 2 input tables, but 2 input files Exactly what we have to do is we have one file with the addresses and another that is a catalog ( with swear words ) and we find one of those swear word in the address , then we have to blank it. The catalog file with the swear word is not fixed , ...

Hello, We have a small table , that contains "words". Then I have a table with one field of address What I have to do is to check if the address contains the words". In SQL is something like select * from table_adress , table_words where table_adress.address like '%words%' As we are n...