Loading in Import Manager

[Former Member]

Hi,

I have following questions for loading in import Manager

1. How to create a clone for a source field to map it to Remote Key for avoiding duplicates.

2.What option to choose to update/replace the duplicate key row other than key fields.

3.Is the Match record process is a very slow process or my system has any issue that I should check to address this slow Import process when source table rows are in the range of 100K

Thanks in advance for all the help

_reo

[Former Member]

Found the answer

[Former Member]

Hi,

Here are my answers:

1. Once you select your source from the source drop down, you will see your Source structure on the "Source Hierarchy" pane. Here, select the field you would like to clone -> Right Click -> Select "Clone" option.

2. In "Match Records" tab, you can choose to "Update all Mapped fields" or "Update Null fields only" or "Replace" for the "Default Import Action".

3. Import speed/the number of records that can be imported per import also depends on the System on which Import Manager is installed and accessed. I would suggest to split the source file into multiple files and then import them one after the other.

Hope this helps.

Regards,

Rajani