Is there a way we can join 2 tables in DB through Boomi and fetch the details from those 2 tables using primary key?
I have first table 'a' with columns number, name and address and second table 'b' with columns number, designation,salary.
I need to join table 1 with table 2 with condition a.number=b.number.
and fetch the data which is coming common in both tables.
But I tried executing the process. I got following error:
Embedded message: SQL Errors occurred while processing retrieved data: Conversion failed when converting from a character string to uniqueidentifier.; Caused by: Conversion failed when converting from a character string to uniqueidentifier.