My job design looks like:
Code: Select all
DRS Stage --> xfm -- <Insert> --> DRS1
|
|
<Initialize>
|
V
DRS2
DRS1's constraint is: JobParm = 0
DRS2's constraint is: JobParm = 2
i.e. they are mutually exclusive.
The DRS2 stage does a "truncate then insert rows". There are no input rows linked to this stage, all values are hard coded.
However, this table truncation is occuring regardless of the constraint. Even when JobParm = 0 and link stats show 1 row added (and no rows on the Initialize link), "Show Data" returns an empty table.
1. Is this just "how it works", i.e. the truncation occurs regardless of the constraint on the data that will then be inserted?
2. Is there a way I can conditionally truncate then insert rows (i.e. initialize my table with one row) based on a job parm value?
Thanks,
Scott