While using tMDMinput as lookup from MDM hub (using SOAP UI), we want only one record to load based on the global key condition in the tmap. But this feature is not retrieving even one record, it returns zero rows even though that entity contains records.
When we try to retrieve without the globalKey mapping but applying the "Reload at each row" load type, it dynamically fetches all the records from the MDM hub for that entity. When we declare the GlobalKey mapping, it retrieves zero rows instead of 1 perfect match it should retrieve.
Is there any alternative way of fetching one record, else job may fail when there will be millions of records.
Where do you set the global key condition? Can you please show us the expression?
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!