constraint to " OTHERWISE" for a otherwise link in
Moderators: chulett, rschirm, roy
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!
I can set constraint to " OTHERWISE" for a otherwise link in transformer stage . what does that constraint mean?
thanks very much!
Sorry, but for some silly reason I thought you meant an 'Otherwise' trigger in a Sequence job and were using the word 'constraint' in a more generic manner. Let's start over.
There is no such thing as an 'OTHERWISE' constraint. An empty constraint means the link is not constrained and accepts all rows - unless it is marked as a Reject link. A constraint expression allows records to pass down the link only when it evaluates to 'true'. Reject links are the only ones that behave in an 'otherwise' fashion and that based only on the links before it in the link order.
![Confused :?](./images/smilies/icon_confused.gif)
There is no such thing as an 'OTHERWISE' constraint. An empty constraint means the link is not constrained and accepts all rows - unless it is marked as a Reject link. A constraint expression allows records to pass down the link only when it evaluates to 'true'. Reject links are the only ones that behave in an 'otherwise' fashion and that based only on the links before it in the link order.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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. OTHERWISE is cleared by any output link that accepts the row.
thanks very much!
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. OTHERWISE is cleared by any output link that accepts the row.
thanks very much!
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 catch any rows that have failed to meet constraints on all the previous output links.
v 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. OTHERWISE is cleared by any output link that accepts the row.
v The otherwise link must occur after the output links in link order so it will catch rows that have failed to meet the constraints of all the output links. If it is not last rows may be sent down the otherwise link which satisfy a constraint on a later link and is sent down that link as well.
v Clicking on the Otherwise/Log field so a tick appears and defining a Constraint. This will result in the number of rows written
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 catch any rows that have failed to meet constraints on all the previous output links.
v 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. OTHERWISE is cleared by any output link that accepts the row.
v The otherwise link must occur after the output links in link order so it will catch rows that have failed to meet the constraints of all the output links. If it is not last rows may be sent down the otherwise link which satisfy a constraint on a later link and is sent down that link as well.
v Clicking on the Otherwise/Log field so a tick appears and defining a Constraint. This will result in the number of rows written
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 catch any rows that have failed to meet constraints on all the previous output links.
v 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. OTHERWISE is cleared by any output link that accepts the row.
v The otherwise link must occur after the output links in link order so it will catch rows that have failed to meet the constraints of all the output links. If it is not last rows may be sent down the otherwise link which satisfy a constraint on a later link and is sent down that link as well.
v Clicking on the Otherwise/Log field so a tick appears and defining a Constraint. This will result in the number of rows written
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 catch any rows that have failed to meet constraints on all the previous output links.
v 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. OTHERWISE is cleared by any output link that accepts the row.
v The otherwise link must occur after the output links in link order so it will catch rows that have failed to meet the constraints of all the output links. If it is not last rows may be sent down the otherwise link which satisfy a constraint on a later link and is sent down that link as well.
v Clicking on the Otherwise/Log field so a tick appears and defining a Constraint. This will result in the number of rows written
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 catch any rows that have failed to meet constraints on all the previous output links.
v 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. OTHERWISE is cleared by any output link that accepts the row.
v The otherwise link must occur after the output links in link order so it will catch rows that have failed to meet the constraints of all the output links. If it is not last rows may be sent down the otherwise link which satisfy a constraint on a later link and is sent down that link as well.
v Clicking on the Otherwise/Log field so a tick appears and defining a Constraint. This will result in the number of rows written
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 catch any rows that have failed to meet constraints on all the previous output links.
v 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. OTHERWISE is cleared by any output link that accepts the row.
v The otherwise link must occur after the output links in link order so it will catch rows that have failed to meet the constraints of all the output links. If it is not last rows may be sent down the otherwise link which satisfy a constraint on a later link and is sent down that link as well.
v Clicking on the Otherwise/Log field so a tick appears and defining a Constraint. This will result in the number of rows written