I am using PI 7.0 . There is a requirement to lookup to the external DBs for a number of interfaces(around 35) and the data is supposed to be large and dynamic.
The question is : From performance perspective,it suggestable to use the JDBC lookups / Mapping lookups in XI for all the interfaces. or use the lookups in the legacy systems itself.
Please suggest which would be a performance effective whther use the Lookups within XI or ask the legacy systems to do lookup on their systems.