Hi,
We integrate the user data from Bussiness data. On BC, the user email field is allowed to store several email addresses, in order to send several emails when notifying a certain user. This is a standard fesature of BC (AFAIK).
The issue comes when integrating this data into DW, as the user email field is required to be a valid mail. That is not allowing to store several email addresses. This way, after the integration, users has not a valid email field.
Does anybody experience this issue? How did you solve it? What do you think is the best way to procedure?
Regards,
Tomas