Import: Ignore blank records

[Former Member]

Hi Team,

While automatic import, I am getting few blank records from the source system (All the fields are blank)

These records are getting imported in MDM.

Please suggest on how to ignore importing them.

Thanks,

Priti

[former_member208981]

Thanks All.

[Former Member]

Hi,

Incase you want to skip certain records from being imported you can in the Import Manager, Matching records right click on every individual record in the bottom source records pane and select skip record while allowing update all mapped fields for the other record.

In order to skip records having null values during the auto import you can set the null value handling to ignore.

Its important to note that multiple null entries can be there in a unique column in the MDM table as MDM treats it as a incomplete record.

If the file is being transfered via PI to MDM distribution folder you can have this check put in PI as well to remove these entries in the xml file that is being generated.

Regards,

Aditya.

[shanthi_bhaskar]

you can delete those records in in start routine from SOURCE_PACKAGE

[Former Member]

Hello Priti

Theoretically you can import blank record if :

you have records with unique matching field and null or filled by spaces another fields.

you have set up import action as "Create" or "Update (All Mapped Fields)" or "Replace"

In IM options set up(for records filled NULL values) :

Default NULL interpretation = Overwrite existing values with NULLs

Which import actions you have set up?

Regrads

Kanstantsin Chernichenka