DSXchange

Not exactly sure what you mean by "not very good in JAVA"..... in case you mean that the career prospects aren't that good, or the pay isn't as good, and for future readers of this thread, the ability to "combine" the two is a way to jump-start the DataStage learning curve. A sit...

Hard to say, because it's been a long time since I've used that release.....but check to see exactly "where" you are when you perform lineage and this happens...are you starting at the job, stage, table, or column level? Does the result change if you move "up" or down a level bef...

I've always wanted to do this in a generic routine.....be able to determine exactly "what" column I was working with on the input link, its datatype, length, etc., so that I could apply it everywhere and react differently based on the run-time metadata coming in..........If I need this I u...

FastTrack only sees Database Tables....not Data Files......so they have to be created with formal Host, Database, Schema, Table, Column formatting.... ...assuming that you used DataStage to create the "shared" tables, check this carefully before you go thru the dialog that creates the shar...

At it's most basic, this xml will deliver (for ID=1) two rows for TEST and its contents. I'd probably pull each of the columns as /element/ (without the usual "text()" at the end of them, then concatenate them downstream into one single string, and then do a reverse pivot (collapse the row...

two things I would suggest... a) make sure that your "key" is indicated on the header column. b) include a "containing" element. ...meaning, if you currently have in your xpath something like /message/header/text(), change it so that you have something like /message/AllHeadersAnd...

are those unique elements, as you have stated (header1 vs header2) or are they "repeating" elements? what is the node structure of the document? A well designed xml document will have some sort of repeating "containing" root node, set up for whatever the document is holding, such...

Check your settings...in your first post, you say you have message quantity set to "1". That means read one message and then quit. That one also has to be a -1 if you want it to keep reading. It's a debugging and testing feature. When I build new jobs I ALWAYS set the timeout to something ...

The xmlInput Stage is very consistent...the CLOBs might be screwing it up, but I doubt it.....here are some things to check... a) are you certain that it is only reading the first one? Keep in mind that "downstream" you won't be able to easily tell....it will just keep parsing and sending ...

Are each of the 10 seen downstream as individual rows?.....the xmlInput Stage is going to parse out the xml on each "row" as known to the DS engine.....if you take out the xmlInput Stage and put in, say, a transformer or other stage that can at least pass the CLOB, do you see "10"...

While anything is possible, I've never seen it put something "else" in there. Check your logic and be sure you are debugging this problem directly on the output link from the Stage, and not anywhere downstream.... ...be careful about what it means to have "no value".....if you ha...

try other WSDLs to be sure it's "this" WSDL and not just something happening with the importer.

Ernie

Indeed...and the reporting tooling mentioned is long since gone.

Start a new thread, outline your objectives....there are lots of ways to get at various bits of metadata......depends on what you need.

Ernie

Generally speaking, you want your "key" (it's not a key in the usual sense, in this context it is just an indicator) on the lowest element that repeats as an independent unit for this "path". The stage will "aggregate" the rows (instances) for that node upward from ther...

Write some code that generates SQL CREATE syntax. For the basics of columns, it's not that cryptic. Then reverse engineer it into any of the popular modeling tools that are supported by the Metadata Asset Manager. I just did this for a loosely structured xmi xml structure someone gave me. For my pur...