Comparing columns in the same table to dictate processing

[JPalatianos]

Hi,
We have a requirement to maintain an audit table as follows:

CREATE TABLE PRFWSTG.PRSAUDIT
(
TABLENAME CHARACTER(30)
, PRETABLECOUNT INTEGER
, FILECOUNT INTEGER
, POSTTABLECOUNT INTEGER
, PRS_TIMESTAMP TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)

We are still in development on this and we are updating the various columns in our jobs but would like to as a final step we would like to dictate s processing decision based on the value of
if POSTTABLECOUNT = (PRETABLECOUNT + FILECOUNT) then continue
else email notification.
I thought this would be the easiest piece but am not sure where this can/should go.

Any thoughts or experience with this would be appreciated.
Thanks - - John

[sachin1]

in one transformer you calculate sum of two columns and in second transfomer's constraints, you can make a decision of job processing.

[JPalatianos]

Thank you for your input. A follow up question to your suggestion....
Can I do a similar type thing in a sequnce job to control job execution?

[ray.wurlod]

Yes. You need to get the two values into the job sequence - typically via a job that selects them and loads them into its user status area or writes them into a file. Having retrieved them, you would use a Nested Condition activity with a custom trigger expression to make the decision.