DSXchange

Not sure...could be a lot of things. Here are some questions and also things to consider: a) What are you doing inside your code? Are you calling out to somewhere? performing i/o? Doing heavy calculations? doing your own lookups into an rdbms? b) how many columns? are you going thru a loop for each ...

Congrats, and thanks for the details! ....in theory, if the xpath was the only problem, this one is fixable by hand on a per-job basis prior to the patch, if someone was in a crucial mode with one particular Job.

Ernie

...another way is to build a Server Job that calls the same Web Service, and then use the "Trace" option in the Run Job dialog....select the Web Service Transformer on the left side, and all four boxes on the right...you will get a voluminous log in the DS Director.....and in the center yo...

Congrats! ...and thanks...I continue to tweak the ways to describe this...glad it was clear.

Ernie

I agree it looks confusing, and frankly, I'm not sure why it is called Parent/Child in that Step....I've been using it (HJoin) exclusively for this purpose, and outside of some initial testing when the Stage first came out, I've never had a reason to look at the OrderJoin Step ever again. I suppose ...

regroup for certain, and then probably a join..... Spend time on that "side" of the job separately, so that things don't get too confused...read the data from flat files and make sure you are able to write the xml perfectly with your assembly. I'm currently writing a post on "tips for...

16+ years with it and learning new things every day... I like what Craig said up above. You can be pretty "dangerous" with it in just a couple of days, or a week...but it depends on so many other things...the sources and targets you have, the kinds of transformations you need to do, the st...

Are they truly "independent" repeating nodes at the same level? If so, then in most cases, the appropriate solution is two separate links. They are no different than two separate relational tables coming out of (say) DB2. For a simple example, imagine "company" xml document that ...

This is one of those xml documents that has a fairly poor design.....it would have been better if the element names were truly the metadata...in this case, the property "name" is the metadata. We'll assume for the moment that things like DEPT, Class and SECTION are actually columns on your...

I haven't explicitly seen "these" issues, but as we've discussed earlier, I haven't used the xml Stage in Server since early 8.5. Your issues certainly sound worthy of formally calling whoever provides your support.

Ernie

Very interesting. I can only guess here, based on some best practices I've been working on and observations of the behavior at the "mapping" part of the Composer step. By design, if you map a summary "group" (particular node key and usually the result of a re-group Step) to the &...

I've had similar success using DataStage to read the xml variant of a .dsx file.

Ernie

Thank you Craig! Bless all you admins...!

Ernie

Maybe someone can split this into its own thread. These are two different questions. First, the xmlOutput Stage, by default, will not create elements for columns whose condition is truly "null". The elements simply won't be there for that row. If you have name and phone within person for a...

You should start your own thread, but the equivalent settings in a parallel Job are delimiter NONE and quote character NONE.

Ernie