DSXchange

when it was initially conceived, that feature reacted to the "trace" tab that is in a Server Job at the "run" dialog when you first run the Job. Not sure if it has a way of being triggered in an EE Job or even if it works in a Server Job in 8.1. I stopped using it in lieu of just...

Use a Server Job and a Hash table for insertion and independent lookup purposes instead, if you are unable to use a database.

Ernie

It may have been the names, but also could be that the metadata is simply not connected internally for some reason. What you might want to do is build an extension mapping for connections that don't automatically get created. Extension Mappings can be established to go from Database Column to BI Col...

At the moment I am "assuming" that you have the following....rows that contain some header info, some trailer info, and lots of detail. If you had ten rows after your joins and data collection, the header info is identical for all ten rows, and the trailer information is also identical on ...

It was announced but is still "in the oven". Soon we all hope....

Ernie

based on what you pasted above, I'd say that you are done. Multiple rows for detail and one for header and trailer....?

hmm...

If your header and trailer information has no repeating rows, then what you've done looks great, and in fact, you don't have to do all the lookup stuff as described in the document.

Ernie

It's in the document. Look at the xmlOutput Section where it talks about writing out multiple independent paths.... Then decide what your document is going to look like....do you already have a sample? Create a common key for the rows among the three sources...either manufacture one, or maybe there ...

great! ....it took me a while to figure that one out also. Once I made it my mantra, things got much easier.

Ernie

...by the way, I noticed you mentioned something about not being able to map across "multiple lists"... in the example above, there is only one list ...Address. Do you have others? If so, and they are unrelated, (perhaps, like if you had a list of multiple Dependents), then they would need...

Address "is" the list....so you should be fine. The default behavior is to do exactly what you are looking for...to get two rows, one for each address line, with the same parent info. Hard to say without looking at your assembly, but it could be in your overall scope and mapping that is do...

...a strong recommendation for ANY reading of an xml document and something, for other readers of this thread, that is discussed throughout this forum....there is too great a chance that the sequential stage will react to things like CRLF's embedded in the document --- character sequences that from ...

Congrats. I haven't had to do that because of an error...nor had seen that particular error...glad that got around whatever that error is...

I like the concept though....I've looked at doing things like this with formal xml schema definitions, and the idea is cool when applied to EE: Be able to apply a dynamic EE schema file at run-time for a sequential file that will capture rejections based on things like datatype, without having to fo...

Hard to say...some things to try that might help uncover the problem: a) can you run the service thru a tool like SOAPui? be sure that you can. b) can you run the service in the WSTransformer? sometimes the argument passing is less error prone. c) code the Job as a Server Job...perhaps for productio...