Rfc lookups Vs Value mapping replication

[Former Member]

Hi All,

What is the difference between lookups and Value mapping replication.which one is better in the point of performance.

Thanks & Regards,

Anusha

[udo_martens]

Hi Anusha,

Lookups: Much quicker and easier to implement

Value mapping replication: Better performance, better to monitor

/Udo

[Former Member]

Hello,

In VMR, u are storing key-value pairs in runtime cache of PI system which implies that while doing mapping u can directly access/read data from PI runtime cache, on the contrary in lookups (JDBC, RFC, SOAP or FILE) you have to store data in some external sources/table outside PI and in order to fetch those values u have to make a call while executing ur mapping which can hamper the performance and can lead intermittent connectivity issues.

VMR is certainly having better performance then lookups, but having said that the choice between lookups and VMR is scenario dependent for instance in case u have to create key-value pairs from scratch then VMR can be used in those scenarios however if the data which u want to query already exist in some external tables then u can go with lookups...

Thanks

Amit Srivastava