Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDMEE - ICP Mapping Script vs Like

athlon007Aug 14 2019 — edited Aug 22 2019

Hi FDMEE experts,

I am trying to improve performance during the import/validate step.

I was wondering what is best practices in regards to the below mappings I have. Also performance wise.

Currently our mapping is done via #SCRIPT, within there we have following code (snippet) the arrAccnt is just an example, it basically has 50 accounts. and the fdmResult list is about 300 results long. So for each ICP we have there exists a mapping

arrAccnt = ('11670000',)

ICP = fdmRow.getString("ICP")

if fdmRow.getString("ACCOUNTX") in arrAccnt:

if '_151000_' in ICP:

fdmResult = '1000'

elif '_151002_' in ICP:

fdmResult = '1002'

Or is it better to have a like mapping for each ICP in a separate row?

Source value Target Value

*_151000_* 1000

Thanks for your feedback.

Roman

This post has been answered by user6692921 on Aug 14 2019

Jump to Answer

Added on Aug 14 2019

#business-intelligence-applications, #financial-data-management, #performance-management-applications

8 comments

656 views