Conditional insert into a Target

[sa0309]

I'm needing to insert a row into a target an oracle table based upon a row count being passed from my SQ.

SQ:
COLUMN NAME: COUNT_OUT
Properties: Sql Query Attribute: select count(*) from TAB_A as COUNT_OUT

If COUNT_OUT > 240
insert a row into ORATAB
else
Do nothing

Is there a "conditional" transformation or what would be the best method? I hope this make sense.

Thank you in advance for an thought and suggestions.

 

[rasETL]

I see two possibilities...

One - pass the row thru a Router Transformation using a filter of count. to continue the record on.

Two - Use a SQL Override in the Target Map to insert the row if the count is what you want it.