Search found 53125 matches

by ray.wurlod
Wed Feb 27, 2013 2:43 pm
Forum: General
Topic: changing isadm password
Replies: 1
Views: 984

It's probably best to use DirectoryAdmin.sh to effect the change.
http://pic.dhe.ibm.com/infocenter/iisin ... tcred.html
by ray.wurlod
Tue Feb 26, 2013 11:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: soap header authentication in webservice
Replies: 9
Views: 3373

Try it without using the namespace references but, instead, using the explicit URLs that belong to each namespace. I have found this to work in the past. Sometimes, it seems, the WebServices Transformer stage simply does not work properly with namespace references when the header is customised.
by ray.wurlod
Tue Feb 26, 2013 7:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does SCD Apply to Compound Key Slow Change Dimension Table?
Replies: 8
Views: 2020

The compound should be the business key, though a more efficient fact table would be constructed by amalgamating these into a single column, perhaps with delimiter characters. The Surrogate Key must be an integer of some kind, usually int64 (or even uint64) to allow for growth.
by ray.wurlod
Tue Feb 26, 2013 7:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Changing from Single node to Multi node Configuration
Replies: 15
Views: 11532

Optimization changes never affect explicitly-set partitioning.

Optimization will only insert partitioners where there are none.
by ray.wurlod
Tue Feb 26, 2013 7:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Co Sort functionality using Datastage Generic Job
Replies: 2
Views: 1725

None of your approaches achieves the required result of avoiding CoSort licensing, as you're still planning to invoke the CoSort scripts. Why not try implementing one of them using a Sort stage, perhaps increasing the available memory per node when performing the sort? Make sure your data are partit...
by ray.wurlod
Tue Feb 26, 2013 7:33 pm
Forum: General
Topic: Design scenario for calling sequence multiple times
Replies: 9
Views: 2446

You wouldn't have missed much, so I unprotected it.
by ray.wurlod
Tue Feb 26, 2013 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does SCD Apply to Compound Key Slow Change Dimension Table?
Replies: 8
Views: 2020

Yes. The fact that multiple columns are marked as Key in the metadata drives this behaviour correctly.
by ray.wurlod
Tue Feb 26, 2013 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to capture no of rows processed on link in parallel job
Replies: 18
Views: 5050

Re: @OUTROWNUM can be used in transformer

sudha03_vpr wrote:@OUTROWNUM can be used in transformer to get the number of records coming out of the link.
... per node
by ray.wurlod
Tue Feb 26, 2013 3:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to load CLOB Column?
Replies: 5
Views: 3827

ISO8859-x (for any x) includes "ASCII" characters.
by ray.wurlod
Tue Feb 26, 2013 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Issue
Replies: 7
Views: 3607

Running out of memory during compilation. Is your system under-configured?
by ray.wurlod
Tue Feb 26, 2013 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: date conversion
Replies: 11
Views: 2977

Can we sell you a Business Glossary ? ;)
by ray.wurlod
Tue Feb 26, 2013 3:01 pm
Forum: General
Topic: Installation problem with SQLServer metadata (XA not config)
Replies: 4
Views: 3106

Thank you for posting that. I'm sure it will get someone out of that particular hole more quickly in future.
:)
by ray.wurlod
Tue Feb 26, 2013 2:51 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Column Analysis failure/Connection refused
Replies: 2
Views: 2635

Have you moved the "table definition" into the project?
by ray.wurlod
Tue Feb 26, 2013 12:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: soap header authentication in webservice
Replies: 9
Views: 3373

WebService Client stage is one-way interaction. You need WebService Transfomer stage if you need request-response interaction. As a general rule the default header that gets built is inadequate, particularly if it needs to include security information, so that you're better off building your own in ...
by ray.wurlod
Mon Feb 25, 2013 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Improve - CFF Stage
Replies: 4
Views: 2338

vivekgadwal wrote:Also, you can check and see if "Multiple readers per node" is beneficial for you or not.
Probably not. The problem occurs when writing a file.