DSXchange

You have to first go to the Administrator page and establish another Metadata Interchange Server that is pointing to a Windows machine....if you are a linux or Unix site for Information Server, you will typically have "two" Metadata Interchange Servers configured.

Ernie

As noted above, < is an important part of xml ---- for whenever you have tag characters that might confuse a parser. It could be the problem but it also might be a red herring. A better debugging technique, as noted above, is not to remove the file but "edit" it....... Remove just the &...

There definitely were some improvements made to support "import" and "include" statements in the xsd portion of a wsdl, but I can't remember when...it was a special patch years ago, maybe against 8.1 (?).....and there still may be "some" constructs that the importer doe...

...since the ABC Segment doesn't have any identifying characteristics (a typical xml design where uniqueness is important might have a sub-node that is a sort of header, directly underneath ABC, or else an attribute, like abc_ID="01" directly inside the ABC_Segment element), one suggestion...

This is a great thread because it illustrates the flexibility in DataStage to create a solution in lots of ways, and also shows that there are important functional AND non-functional decisions that have to be made. Obviously, there aren't any realistic limits here...you can write to a whole lot of t...

99.99 % of the time, it's because an existing MQ environment contains source data that is critical to your application.....DataStage isn't dictating the need for MQ vs flat files --- the need for real time and the use of MQ at the site is what is dictating it. Same for targets.......we write to MQ b...

I remember doing this and realizing that it needed everything in a single large column. ...so I concatenated all the values together, row after row, followed by CRLFs, and then used an aggregator to get the "last" value for each key (each "city"). The output derivation stays red,...

I haven't seen any way to make changes to the methodology of the search using the "built in" method.

Ernie

Good questions/thoughts, Vincent... Some additional details.... Data Lineage includes any and all assets [Extended Data Sources (Applications and others), Database Tables (and their columns) Data Files (and their fields), BI model stuff] and shows the DataStage Jobs and/or the Extension Mappings tha...

...Before you play with the reject logic, set the facet constraint to fatal and just recomiple and run. See if the job dies. Easy way to check if your xsd was imported properly and that your enumeration is being recognized and checked.

Ernie

To take advantage of the reject feature, look carefully at the tree on the right after you choose "reject". I don't have access to DataStage at the moment, so I can't remember what it is called, but you will now see an additional boolean "field" that you can work with .....use th...

Are you also creating the xml via DataStage ? If so, best to just go directly from xml stage to mq....... If not, use a server job and go from folder to mq. The folder stage is designed to read whole files into a column.

Ernie

The method used to create the xml won't matter.....go look at it again, and find and review the best practices document noted above. You will have one xml stage for each of your repeating groups (or at least for the first two)....then for the third, you combine the others with it after performing a ...

wait..... reading thru this again..... you said you needed "two address blocks".....but you don't... according to your details, you need one address block of .....UsageType ....and another one of .....UsageType_2 That's just additional columns. The first usage type column on the link will ...

That's an interesting line of data..... hard to say if it is the cause of your problem, but if that's the xml that you are trying to read, the problem probably isn't the < --- it's the < and the > that _arent_ escaped as > and &lt ....this is text inside of an element called "Run"........