Search found 42189 matches

by chulett
Thu Sep 24, 2009 9:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Slowly changing fact
Replies: 14
Views: 5389

Right, my bad acronym... some kind of "Type 3 SCF" then. :wink:
by chulett
Thu Sep 24, 2009 7:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aborts after 50 warning messages
Replies: 13
Views: 11472

That Administrator setting is a default, something that only new jobs inherit at creation time. It doesn't affect existing jobs.
by chulett
Thu Sep 24, 2009 7:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Slowly changing fact
Replies: 14
Views: 5389

I'm assuming this is a Type 3 SCD, current and previous values being stored.
by chulett
Thu Sep 24, 2009 5:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Slowly changing fact
Replies: 14
Views: 5389

Then you don't need "two streams". And it's just a simple hashed file check and some derivation song and dance for the update stream.
by chulett
Thu Sep 24, 2009 5:46 pm
Forum: General
Topic: capture duplicate
Replies: 9
Views: 2515

I too assumed that was not really the case.
by chulett
Thu Sep 24, 2009 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Slowly changing fact
Replies: 14
Views: 5389

For the 'unchanged value in the lookup' condition, do you really need to do anything or can that record just be discarded?
by chulett
Thu Sep 24, 2009 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: [oraUpsert.C:1852]
Replies: 2
Views: 1306

What stage are you using? What settings / properties are set in the stage?
by chulett
Thu Sep 24, 2009 3:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job control process (pid 17008) has failed
Replies: 2
Views: 1505

So, does the Server job run correctly? Is the process failure noted in the Server job's log or the Sequence job's log? Any idea where in the flow that pid is failing or what the pid is associated with? Perhaps you could ready a telnet windows on the server for something simple like "ps -ef |gre...
by chulett
Thu Sep 24, 2009 12:37 pm
Forum: General
Topic: multiple datastage installation
Replies: 1
Views: 1458

No, you need the credentials, either directly at the command line or you can look into the -file option.
by chulett
Thu Sep 24, 2009 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transaction handling in ODBC Connector stage
Replies: 10
Views: 2152

No, it simply means that no commits are done until the job completes normally, if the job aborts all work will be rolled back. Which is exactly what you wanted, I assume.
by chulett
Thu Sep 24, 2009 9:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One project hangs attempting to connect
Replies: 7
Views: 3477

More information is trickling in and clarifying the situation. We can all connect from the Designer client but not the Director or the Manager. :?

Curiouser and curiouser...
by chulett
Thu Sep 24, 2009 8:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One project hangs attempting to connect
Replies: 7
Views: 3477

Here's an interesting bit of additional news. I had assumed the problem was affecting everyone but that's not the case. Some people can connect to the project and some cannot.

What would cause something like that? :?
by chulett
Thu Sep 24, 2009 8:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: connecting DS 7.5 to ORACLE 10G
Replies: 3
Views: 1260

No, re-read my message, 7.5x2 is the only version (before 8) that will run PX jobs on Windows. Just wanted to make sure there was a point to all this.
by chulett
Thu Sep 24, 2009 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: connecting DS 7.5 to ORACLE 10G
Replies: 3
Views: 1260

Unless this is specifically the 7.5x2 version (note the 'x') you'll never get it running jobs on Windows. Never mind the fact that XP is not a supported O/S.
by chulett
Thu Sep 24, 2009 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transaction handling in ODBC Connector stage
Replies: 10
Views: 2152

Set the interval to zero, as long as it is a count and not elapsed time. :?