Just to elaborate, compare values of source and destination mapped variables, if both or same, ignore only that particular variable of record and insert others.  

Not sure I understand completely.  Do you mean to ignore table record(s) completely or just an element of table record(s)?

ignore just element of the table records. we are inserting around 12 elements for each record. for example if current location is same as new location, ignore only location and proceed with inserting remaining 11 variables.

ignore just element of the table records. we are inserting around 12 elements for each record. for example if current location is same as new location, ignore only location and proceed with inserting remaining 11 variables.

Still not understanding why as this seems like a complete waste of time, money, and development.  The intent of a CIT scenario is to insert, update, or delete table records, so if a source element is the same value as a destination element, then this isn't really even an update and CIT scenario processing is not going to speed up drastically.  In fact, processing speed could slow since obtaining destination value to be used for comparison.

But I digress.  If you want to ignore a mapped element (ie. node), then review help for Function pifIgnoreNodeMapping(strMsg As String) As Long...

- amPortfolio

   - lLocaId

      IF SourceValue = TargetValue THEN

         pifIgnoreNodeMapping()

      ELSE

         RetVal = SourceValue

      END IF