Skip to Content
0
Former Member
Sep 13, 2007 at 04:45 PM

Start routine in Transformation

16 Views

Hello,

Is this statement correct.

DELETE SOURCE_PACKAGE WHERE DEL_TYPE ne 'LF' or DEL_TYPE ne 'BV' or

DEL_TYPE ne 'NL'.

I have written this statement in start routine and strangely it deletes all the records of the Source_Package though I see there are records with DEL_TYPE = 'LF' and 'BV' and 'NL'.

Finally 0 records are loaded into my ODS. Is there anything nissing.

Appreciate your quick response and will be rewarded.

thanks,

KK