Search found 53125 matches

by ray.wurlod
Tue Nov 13, 2007 2:13 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: generate the ETL elasedtime report Directly
Replies: 4
Views: 2636

You could begin by posting a server job question in the server job forum.

U is one of our other posters. I am not he.
by ray.wurlod
Tue Nov 13, 2007 2:10 am
Forum: IBM QualityStage
Topic: qsMatchWeight returns 0
Replies: 2
Views: 1347

Missing values always contribute 0. The idea is that a missing value should prejudice neither the agreement weight nor the disagreement weight. Are there missing values in your records? A totally empty record except for the blocking fields, perhaps? An aggregate match weight of 0 is perfectly feasib...
by ray.wurlod
Tue Nov 13, 2007 2:08 am
Forum: IBM QualityStage
Topic: QS v8 ruleset issue
Replies: 3
Views: 1735

If you're on an earlier version than 8, deploy any job that uses the rule set.

"Provision" is, to all intents and purposes, the new word for "deploy" - though it has to do somewhere else (the common repository for IIS) of course.
by ray.wurlod
Mon Nov 12, 2007 11:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage VS Outer Join
Replies: 12
Views: 5311

You should also scrutinize (with an intense scruit) whether you really need all those columns and all those rows in your reference data set. For example, if all you are determining is existence, all you need is key columns. If you're mapping business to surrogate key, all you need is those two keys....
by ray.wurlod
Mon Nov 12, 2007 11:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to enumerate domain groups
Replies: 7
Views: 3693

Of course, on Windows it doesn't have the leading dot, but does have its "hidden" attribute set. And, if you have not configured any security through DataStage roles, these files ARE absent - not missing. They only come into existence if you modify the role-based security in Administrator client. It...
by ray.wurlod
Mon Nov 12, 2007 11:40 pm
Forum: General
Topic: Reasons for moving to version 8 from 6.5
Replies: 6
Views: 2647

There's hundreds of thousands of advantage$ for IBM, too!
:wink:
by ray.wurlod
Mon Nov 12, 2007 9:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage VS Outer Join
Replies: 12
Views: 5311

No documentation is available other than the manuals, the training classes and the conference presentations. You have to attend to get the last two.

It's supply and demand - if you keep running out of resources, supply more (physical memory, disk space, etc.) or reduce demand.
by ray.wurlod
Mon Nov 12, 2007 9:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "Rebuild Repository indices"can do what?and when w
Replies: 1
Views: 986

Your DataStage Repository is a database schema in which your designs and runtime information are stored. Because it is a database schema it has database tables for storing these things. The tables are indexed. If the indexes ever lose synchronization, it becomes necessary to rebuild them. You should...
by ray.wurlod
Mon Nov 12, 2007 9:33 pm
Forum: General
Topic: Reasons for moving to version 8 from 6.5
Replies: 6
Views: 2647

Not much for server-only sites. Connectors and parameter sets: good for new development, no value for existing jobs.

Most of the goodies are for parallel jobs - as Craig says, that's a whole new licence.
by ray.wurlod
Mon Nov 12, 2007 7:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Ora_Xfr_seq- Date conversion
Replies: 2
Views: 890

Welcome aboard. :D Try it with no conversion at all, and see what you get in the target file. Post that result here, then we'll offer advice. You will probably need to apply an Iconv() function before using the Oconv() function, but exactly what form the second argument of each needs to take depends...
by ray.wurlod
Mon Nov 12, 2007 6:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logic Question
Replies: 18
Views: 3588

You give the SQL statement in the stage that is servicing your reference link.

As for "in detail", perhaps purchasing premium membership would permit you to read my reply in its entirety.
by ray.wurlod
Mon Nov 12, 2007 1:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Detecting new line in a string
Replies: 5
Views: 1173

It would aid diagnosis were you to post the code of your routine. What makes you think that "lines" (presumably separate cells) in Excel have operating system terminators? Or they all in the one cell? For that matter, how is the set of values being obtained from Excel by your routine? Did you double...
by ray.wurlod
Mon Nov 12, 2007 1:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: query on Change_Capture
Replies: 3
Views: 1332

Purposive Note
DSXchange is not intended as a substitute either for training or for support.
by ray.wurlod
Mon Nov 12, 2007 1:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: main_program: "same" operator may not have a parti
Replies: 9
Views: 3906

The message seems to imply that somewhere in the job there is an input link on which there is no partitioner/collector defined, or that Same has been selected as the partitioning/collecting algorithm but there is non-partitioned data arriving. For example, SeqFile (sequential) ----> AnyStage (parall...
by ray.wurlod
Mon Nov 12, 2007 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort the job from "After job subroutine"
Replies: 21
Views: 10455

Precisely what is the relationship between that last question and the subject of the thread - abort the job from "After job subroutine"?