OR Condition in Lookup Transformation

[prophecyslides]

Is this possible or is there anyway to work around this limitation?

I am trying to accomplish something like this:

activation_date <= transaction_date
(deactivation_date > transaction_date or
deactivation_date is null)

 

[vaass]

Hi

I don't understand ur question, is both the activation_date and de_activation date to be checked or...something else...pls explain further

 

[prophecyslides]

Notice the OR condition where it check deactivation_date > transaction_date OR deactivation_date IS NULL

It would actually be something like:
IN_transaction_date as an input to the lookup.

How can I put the OR in a Lookup transformation?

 

[sashwath]

Your validation would be
IIF(DECODE(deactivation_date>in_transactiondate,1,0)=0 OR
NOT ISNULL(deactivation_date )),TRUE,FALSE

)