on 06-10-2013 7:41 AM
Hi All,
What is the difference between lookups and Value mapping replication.which one is better in the point of performance.
Thanks & Regards,
Anusha
Hi Anusha,
Lookups: Much quicker and easier to implement
Value mapping replication: Better performance, better to monitor
/Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.