Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.
Please consider addressing the following when creating your topic:
- What have you tried?
We have created a Source using “Generic JDBC Connector” and there is an attribute in DB named as “SECONDARY_LOCATION_CODE” which we have marked as MULTI-VALUED.
Note that for 1 user, this DB can have more than 1 row. Now, for one of the user, there are 4 rows and there value of “SECONDARY_LOCATION_CODE” column in DB for that user is as follows.
L1
L2
L1
L1
- What errors did you face (share screenshots)?
But, when the aggregation is completed, we are getting values in Account Attribute named as “SECONDARY_LOCATION_CODE” as below.
L1
L2
Hence, the ask here is whether from DB, can we bring all the 4 values as-is? I know for a reason that in SailPoint ISC, for Multi-Valued attributes, the duplicate values are eliminated and only distinct values are kept.
Please provide some inside on this?