This content has been marked as final. Show 5 replies
It might be a mapping problem - especially at those data volumes I wouldn't expect such a dramatic processing time.1 person found this helpful
Take a look at the import analysis report under System Reports.
Have you broken down the times by step (import, validation, export, load)?1 person found this helpful
Import times are impacted by volume of data as well as import map settings. The more scripts, formulas, 'like' and 'between' records you have, the longer it will take.
Validation time is a function of valid cell combinations. The only real way to speed this up is to reduce either the volume of data in FDM at time of validation or reduce the valid cell intersections.
Export time is just the time it takes to save the file to the server then the time it takes to upload to target system. This is usually the quickest step and there is not a lot you can do about it.
This is what is expected from FDM, if you have more this much of volume. FDM takes time to import, map, delete data from seg tables, datamap tables. If you analyse your import analysis report you can see the times for each of these actions. The obvious solution is to break big loactions into multiple small locations and run them parallely. You may also want to involve your DBA to look at the tables & queries while the process is running. He maygive you pointers to imporve the performance like index creations etc.1 person found this helpful
Thanks for your responses. I'm having a look a few things suggested and will update shortly. The 'Imnport Process Analysis' has proved useful and may have highlighted an improvement I could do in mappings for one segment.
The report did identify potential issues and when I changed the mappings to be explicit as opposed to ??? the timings have certainly improved. Thanks to all who responded.