Search found 37 matches

by cetzhbo
Fri May 16, 2008 12:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: create surrogate key using @INROWNUM/@OUTROWNUM/@NUMPARTITIO
Replies: 7
Views: 4839

thanks, so please tell me what do these parameter do ? please give me some scenario about that.
by cetzhbo
Fri May 16, 2008 12:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: null input in transformer stage
Replies: 3
Views: 1085

this is the abstract for v8 guide:

" If you use input columns in an output column expression, be aware that a null value in that input column will cause the row to be dropped or, if a
reject link has been defined, rejected. "

my question point to that.

thanks very much!
by cetzhbo
Fri May 16, 2008 11:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: constraint to " OTHERWISE" for a otherwise link in
Replies: 18
Views: 3756

thanks friends, but this otherwise link is not a reject link. and following is as abstract for v8 developer guide, hopeful you can make it clear: A constraint otherwise link can be defined by: v Clicking on the Otherwise/Log field so a tick appears and leaving the Constraint fields blank. This will ...
by cetzhbo
Fri May 16, 2008 11:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: constraint to " OTHERWISE" for a otherwise link in
Replies: 18
Views: 3756

thanks friends, but this otherwise link is not a reject link. and following is as abstract for v8 developer guide, hopeful you can make it clear: A constraint otherwise link can be defined by: v Clicking on the Otherwise/Log field so a tick appears and leaving the Constraint fields blank. This will ...
by cetzhbo
Fri May 16, 2008 11:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: constraint to " OTHERWISE" for a otherwise link in
Replies: 18
Views: 3756

thanks friends, but this otherwise link is not a reject link. and following is as abstract for v8 developer guide, hopeful you can make it clear: A constraint otherwise link can be defined by: v Clicking on the Otherwise/Log field so a tick appears and leaving the Constraint fields blank. This will ...
by cetzhbo
Fri May 16, 2008 9:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: constraint to " OTHERWISE" for a otherwise link in
Replies: 18
Views: 3756

Hi chulett, that is true, please read following words from v8: ( this is definitly not "Otherwise/Log field" ) A constraint otherwise link can be defined by: Set the constraint to OTHERWISE. This will be set whenever a row is rejected on a link because the row fails to match a constraint. ...
by cetzhbo
Fri May 16, 2008 9:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: create surrogate key using @INROWNUM/@OUTROWNUM/@NUMPARTITIO
Replies: 7
Views: 4839

thanks, so please tell me what do these parameter do ? please give me some scenario about that.
by cetzhbo
Fri May 16, 2008 9:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: constraint to " OTHERWISE" for a otherwise link in
Replies: 18
Views: 3756

thanks, but if I don't set this constraint for otherwise link, I think it also catch all the rows when there is not other constraint fired. is that right ? if that is it, why should we need use this setting?
by cetzhbo
Fri May 16, 2008 9:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: create surrogate key using @INROWNUM/@OUTROWNUM/@NUMPARTITIO
Replies: 7
Views: 4839

create surrogate key using @INROWNUM/@OUTROWNUM/@NUMPARTITIO

Hello Gurus,

How can I create surrogate key using @INROWNUM/@OUTROWNUM/@NUMPARTITIONS/@PARTITIONNUM, which will minimum the number space ? such as " 1, 2,3 " is better, however " 1, 18, 39" is bad.

thanks very much!
by cetzhbo
Fri May 16, 2008 8:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: constraint for each output link
Replies: 5
Views: 1580

thanks, but does stage variable/constraint/output derivation are evaluated row by row ?
by cetzhbo
Fri May 16, 2008 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: constraint to " OTHERWISE" for a otherwise link in
Replies: 18
Views: 3756

constraint to " OTHERWISE" for a otherwise link in

Hello Gurus,

I can set constraint to " OTHERWISE" for a otherwise link in transformer stage . what does that constraint mean?

thanks very much!
by cetzhbo
Fri May 16, 2008 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: null input in transformer stage
Replies: 3
Views: 1085

null input in transformer stage

Hello Gurus, in transformer stage, if a input columne is null, and this is direct mapping, so corresponding output should be null. but if this null input columne appears in the output derivation, corresponding output will be rejected. how to make this null input column output with derivation if I wa...