Search found 3835 matches

by eostic
Fri Jul 16, 2010 6:38 am
Forum:
Topic: Data Lineage for other ETL tools....
Replies: 5
Views: 3363

Too much to cover in a brief entry here, but some things to consider are: a) what are the critical paths of lineage for your enterprise...? What business reporting system(s) create the most work for lineage needs (which ones raise the most questions from the most influential teams of decision makers...
by eostic
Thu Jul 15, 2010 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: count number of element count within a xml file in Datastage
Replies: 1
Views: 1571

You can use xsl directly inside of the stage, and produce the answer...it's a bit tricky, but can be done if you follow the output requirements per the documentation. I haven't done it in years and not sure I have an example laying around...someone else on the forum might have one also. I'll take a ...
by eostic
Thu Jul 15, 2010 2:24 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: regarding response to the service
Replies: 9
Views: 5678

Yes.... just put a single column on the output link of your xmlOutput Stage....make it longvarchar with some long length and put a single "/" in the Description.......the whole completed xml will go into a single column. ...test it first by sending to a flat file with no delimiter and no q...
by eostic
Thu Jul 15, 2010 2:22 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: generating WSDL
Replies: 2
Views: 2777

ISD dictates the WSDL....it is generated by review of the metadata on the input and output links.... I like to build a dummy job (wisdInput to Transformer to wisdOutput), with all of my columns that I expect to have on the request and the response, compile it and then deploy it..... ...and then dist...
by eostic
Thu Jul 15, 2010 11:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Formatting Issues
Replies: 5
Views: 1587

Check what Craig notes above....go back to all of your "upstream" xmlOutput Stage....find the "generate chunk" check box...... it looks like you are putting headers in the chunks as you create them....... ...and do some debugging...send the partial chunks to a file or peek so you...
by eostic
Thu Jul 15, 2010 10:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Formatting Issues
Replies: 5
Views: 1587

Check what Craig notes above....go back to all of your "upstream" xmlOutput Stage....find the "generate chunk" check box...... it looks like you are putting headers in the chunks as you create them....... ...and do some debugging...send the partial chunks to a file or peek so you...
by eostic
Thu Jul 15, 2010 10:44 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: regarding response to the service
Replies: 9
Views: 5678

I'm sorry...I don't understand your question.....

Ernie
by eostic
Thu Jul 15, 2010 10:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract and Load with XML
Replies: 1
Views: 843

How complex is the xml on either side? ...where complexity is defined as having multiple repeating and independent nodes (think a company xml document with a node for "n" employees and another node for "m" assets)...... Either way, the answers are all here...you need to parse the...
by eostic
Wed Jul 14, 2010 5:51 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: regarding response to the service
Replies: 9
Views: 5678

I'm not entirely sure, but I think the SOAP representation for a null xml element (one that is allowed to be nillable, as you showed us above) is to simply not include it in the body. The tool receiving the response should know that if the element isn't present, it must be null....... xml is very fl...
by eostic
Wed Jul 14, 2010 5:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does XML file have default XSD defined..
Replies: 1
Views: 732

No...in the current xml stages the only xsd specified would be the one in the header of the instance document itself.........you can use an xsd for import, but if you want validation at runtime, the xsd in the SchemaLocation (or similar) attribute in the header is where the xsd will be found.
by eostic
Wed Jul 14, 2010 5:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Characters in XML
Replies: 2
Views: 983

Use the Data Element of "XML" on the input link of the xmlOutput Stage. That tells the Stage not to "escape" the xml tag characters.

Ernie
by eostic
Wed Jul 14, 2010 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Integrating UI with Datastage
Replies: 5
Views: 1989

Implement ISD.....then you can kick of a job easily with just a "button", and the .NET developer will have to do very little to implement it beyond importing a WSDL defintion.....

...of course, this means you need a license for ISD...

Ernie
by eostic
Wed Jul 14, 2010 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join in FastTrack
Replies: 7
Views: 2044

...but it "can" generate 7.5 jobs as a .dsx..... To enable the DataStage XML export feature perform the following steps for each FastTrack client that has to be enabled: 1.Close your FastTrack client if it is currently running. 2.Open the mozart.ini file that is located at: <information se...
by eostic
Tue Jul 13, 2010 9:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Repetitive Elements
Replies: 6
Views: 3164

You have independent repeating child nodes. Find the best practices in the threads here.....study the techniques needed to build multiple nodes and put them together...basically, you build each one separately in their own xmlOutput Stage, then bring them together at the end in a final xmlOutput Stage.
by eostic
Tue Jul 13, 2010 9:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Message splitup
Replies: 6
Views: 2517

Are you doing a destructive read? ...or are you browsing? ("keep" option)? Unlikely that it is splitting up messages, but it most certainly every node will browse the same message......