Hi,
I’m currently working on JDBC integration. We are using account aggregation query to fetch all the records from end target to IDN. Same query which worked for SQL giving us different/lesser number of records in IDN.
As shown in attached its not able to get the records with same account ID but different case. How can we get these records at IDN as 2 different records.
Hi @Shivaleela
Did you forget to attach it?
Could you please share the query you are using…
Thanks
Raghu
I also do not see an attachment.
Additionally, the following details would be helpful to those responding to your question about the JDBC Connector:
In reading your response, it sounds like you have 2 records with the same ID that differ only by case. It also sounds like you would like those to be 2 separate records.
I believe when IDN reads in the data it sees the ID as case-insensitive and will update the same object for both rows.
If you look at the resulting id, does it include data from both rows? or from the last row read?
You forgot the attachment. But as per your configuration if the unique value itself is duplicate and the only uniqueness is their case then it will not work. Your account name should be unique.
Let me know if you need further input.
Thanks
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.