how to ignore inactive records on target table before an import.

[chucksimonds]

Is there a way to ignore inactive records on the target table before matching the records? Using an onBefore script to ignore inactive records ignores the inactive record, but also it ignores/drops the source record so it is not available to match on an existing active record. I would like to ignore the false record and still match on the active record. Is it possible to use a script/query to only pull in (process) the active records on the target table? Thanks!

[Chuck Tomasi]

Hi Chuck,

I'm having a difficult time understanding what you are looking to filter out. The import process imports everything from the data source (example XLS) and puts it in the staging (import set) table, then the transform map processes those records. Using a field map, it matches to the target record to determine if it's an insert or update.

Can you help me understand if you're trying to filter the import set records, or skipping target records? I'm not clear. Sorry.

[chucksimonds]

Basically trying to ignore (not process) inactive records on the target table during the transform. Using onBefore script to ignore cause both the imported record (source) and target record to be ignored. Example is for sys_user table. I have two records with same names (one active one inactive). During transform the aource record matches to the inactive record (an onBefore script to ignore it ignores the source record and inactive target record) I want to match the source record to the active target record.

[Chuck Tomasi]

Hi Chuck,

I'm not sure if that can be done or not. I'll do some checking. Can you tell me what the use case is for this? I'm intrigued?

My concern is that you have record A in the target table with some ID "1234" and inactive, you could be creating a new record "B" with some ID "1234". Is that something you are aware of? Interested in? Need?

[chucksimonds]

We have two feeds/imports for our user table. One matches on user_name (must be unique) and this is where we do our inserts if needed.

The second import only updates information for existing records, but does not use (and does not have available) the user_name, so it matches on the name (first last name). Rignt now there are users records with same first/last names. One record is active, the other is inactive and it always seems to match on the inactive record first. I'm using an onBefore script in the transform to bypass when it matches on the inactive target record, but the active record is never processed because it bypasses both the target record and the import (source) record. if I eliminate the inactive records coming into the transform, it will have to match the active record and that is what I want. Hope this helps explain it better.