DSXchange

Yes...take a look at istool. As of about 8.1.2, istool was updated to support BG...

Ernie

...it's so that you can manage more complex transactions.....having multiple SQL statements (ie..a link for table1 and a link for table2) on the same unit of work.

Ernie

As noted earlier, you can opt to use the new XML Staqe. If you do so, forget about the header in your xml document. You import "the" xsd as part of the design process. That xsd, which is imported via the Library Manager, will guide your entire design of the Assembly, and control your valid...

It "sounds" like you are using the xmlInput Stage. This stage finds the xsd according to the value in the header. I recall issues in the past when the value of SchemaLocation had to be the Project directory, but in either case, the value always has to be "in the header" in order ...

I'm still not entirely sure of your objective, because I don't see exactly how the products match each other, but it sounds like you want to have your product node followed by a delta node, then another product node, etc. Are you building the "entire" tree of xml in each of the upstream xm...

Try pivoting it first so that the number of rows in the incoming link "list" is the same as the number of nodes you want in your target "list". (ie..get email onto its own row)

Ernie

Hi Praveen...I don't think I entirely understand your objective ---- not sure what the issue might be.... one thought, without knowing more detail, is to play around with the column that has your "key" indicator on the input link of the xmlOutput Stage. That will impact the aggregation lev...

...if you are in 8.1.2 or higher, use the Info Server Web Console and the Repository Tab........find the table/schema/database that you need to remove and delete it there.

Then re-import as necessary with desired naming convention.

Ernie

Whatever Stage you use, be sure it supports the ability to use a "sparse" lookup (one that goes back to the database for each lookup).

Ernie

Don't try just one service. Try many....do a lot of tests......there was a thread on this subject just recently --- do a lot of searches. Check out my blog in my signature...there are entries there on Web Services in the Table of Contents......go to www.xmethods.net ....look at the Termperature Conv...

Could be lots of things.... Try others....use also other testing tools, such as Actional Diagnostics and SOAP UI....go to www.xmethods.net ...some good ones there such as Temperature Conversions..... If they all get a timeout, then something else is happening. Can the DS Server machine get to the ou...

Nullable, nillable...whatever. :) xml spec uses nillable... DataStage has used nullable as have other tooling ....is it as nilable somewhere? I didn't see it. As for your issue, not sure exactly...could be lots of things, but I'm not sure what you mean by "this element has a data value in the f...

The mapping can be a bit confusing, as the "available" elements are dictated by what you specify "along the way" as you go down the mapping page thru the hierarchy.....here's how I generally like to do it... a) find the node path that you want. b) determine how "deep" y...

Congrats! Nice work. What I like to do is to capture a successful SOAP envelope from the owner of the service....and then work in mimicking that, even if I just hard code it at first...and as you discovered, the "header" details are just a chunk that you define on your own upstream. Ernie

Do some searching..this looks like the classic "trying to read the xml document with a Sequential Stage"..... Search the forum or follow the link below to my blog and find the xml entries in the table of contents...look for the various ways to read xml using the External Source Stage.