Maximum records in FIM mapping table

[deepesh_kumar]

Hi All,

What is the maximum number of mapping in FIM table without much performance issue? I am sure that it depends on the system configuration / transaction data volume etc... Any high level view would be helpful.

Regards

[Former Member · Accepted solution]

Hi,

Please refer to the following note:

1670001 - Slow Performance when accessing
a mapping table with more than 500 rows in Finciancial Info...

1756742 - FIM mapping table column number - FIM10.0

1689176 - Out of memory at line: xx when
copying from MS Excel into FIM Mapping table

Regards,

Soumaya

[deepesh_kumar · Accepted solution]

Hi Soumaya,

Thanks for the reply. I have seen the notes, what I am interested is in your experience.

What is the maximum number of FIM mapping records with which a job can run below 5 mins

if the transaction data coming in a flat file is in the range of 1000 - 10000 records...

I am having a mapping table with large number of mappings 55000 and job run time is 20 - 25 mins for 10000 records. I am looking for options to optimize the performance of the job.

Regards