Search found 3835 matches

by eostic
Fri Dec 14, 2012 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repetition Elements in XML
Replies: 5
Views: 2123

Each repeating node needs its own "output link"....not its own stage. You can have one xmlInput Stage (or xml stage for anyone reading this that has 8.5+ and wants to use the xml stage) with as many output links as you want...... you want to parse the xml only once...but each separate repe...
by eostic
Fri Dec 14, 2012 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repetition Elements in XML
Replies: 5
Views: 2123

Each repeating node needs its own "output link"....not its own stage. You can have one xmlInput Stage (or xml stage for anyone reading this that has 8.5+ and wants to use the xml stage) with as many output links as you want...... you want to parse the xml only once...but each separate repe...
by eostic
Thu Dec 13, 2012 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output Generation
Replies: 4
Views: 1509

the repeating node (accessory) is dictated by the number of "rows" that come in for that particular node. So....from a basic perspective, you would want to pivot each row so that you have "n" rows for each model, where each row contains the model and spec information and one inst...
by eostic
Wed Dec 12, 2012 6:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with XML_Output Stage
Replies: 3
Views: 1511

I don't know if you can run it that way. You might be able to do, but I can't confirm. The xmlInput and xmlOutput Stages are not native Operators. They were written long before osh existed. As such, they may have different characteristics that prevent what you are trying to do, so I am not surprised...
by eostic
Tue Dec 11, 2012 2:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Java Compilation error
Replies: 9
Views: 4849

it's all about your classpath(s) at development and compile time, the manner in which the import statements are set up...where you have jar files and other resources......all in all...java development things. Make sure you have a java resource available for the work. Most will have a java IDE alread...
by eostic
Tue Dec 11, 2012 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parsing in datastage and Oracle
Replies: 2
Views: 1407

It's a comparison that can't be made on pure speed or technology, regardless of which parser does it faster. Databases have had data types for xml for a long time....each has some very interesting and unique technology for it. Nice support for certain xml constructs, compression, etc. ...but many si...
by eostic
Mon Dec 10, 2012 9:18 pm
Forum:
Topic: Customise the Appearance of Business Glossary...
Replies: 2
Views: 2011

you can change the text and the logo on the base search page, but that is about it, short of writing your own app.
by eostic
Mon Dec 10, 2012 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connecting to LDAP
Replies: 16
Views: 9208

As has been noted above in various replies, you need one or more of the following: a) someone at your company, who is responsible for LDAP, to research available (if any) ODBC drivers. You can't easily do this yourself--- it needs to be someone who is very close to the LDAP environment at your site,...
by eostic
Sun Dec 09, 2012 6:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeating Sequences in XML input stage
Replies: 6
Views: 3140

A good reminder and lesson for everyone.....if you are dealing with xml the content is nearly ALWAYS going to be 100 character data. Make everything varchar and you will be a lot more successful. Convert it later only if you need to.

Ernie
by eostic
Fri Dec 07, 2012 5:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TWO DIFFERENT DATA FLOWS IN A SINGLE JOB
Replies: 13
Views: 3952

Does it matter? The key point throughout this thread is that "while it can be done", the management complexities about having two flows in the same Job vs two separate Jobs typically outweighs any benefit or reasons for multiples in a single Job. DataStage has allowed this since release 1,...
by eostic
Thu Dec 06, 2012 3:23 pm
Forum:
Topic: Questions about Metadata Asset Manager
Replies: 1
Views: 2117

I am guessing here, but it sounds like you might be using filtering on the Connector import option.......The addition of more tables may depend on the filtering (if any) that you did the first time. If you selected a particular database, and not filter on specific things below it, then the same impo...
by eostic
Thu Dec 06, 2012 3:19 pm
Forum:
Topic: Lineage with RCP job in Workbench
Replies: 2
Views: 2524

Missed this topic earlier. Yes...MWB can perform lineage thru an RCP job......but...it requires that you have some metadata in order to perform that lineage. Imagine you have a fully RCP enabled job with a relational source stage, a few other stages and then a target relational stage. No column info...
by eostic
Thu Dec 06, 2012 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeating Sequences in XML input stage
Replies: 6
Views: 3140

check something else in your job. sometimes it helps to tear it down and just have one single column on your output link...the PHONE_TYPE_CODE ......your xpath looks good. It should return 2 perfect rows for the content you have up above. something else might be limiting your extraction to a single ...
by eostic
Thu Dec 06, 2012 10:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeating Sequences in XML input stage
Replies: 6
Views: 3140

make sure that something in the MEMBER_PHONE node is marked as the only "key" on the output link.

Choose an element that is ALWAYS existing...maybe PHONE_TYPE_CODE. You should get 2 rows from the sample above.

Ernie
by eostic
Tue Dec 04, 2012 10:45 pm
Forum:
Topic: MetaAsset manager failed to point to bridges
Replies: 2
Views: 3575

Just a guess, but try adding the windows box hostname to your service tier's hosts file if it isn't already.....