Hi All - I am looking for design suggestions to below the following use case. Please guide me . Thanks
1. We have a module for employee - role mapping (1:M)
2. Planners have an option to change employee role (add / delete)
3. There are other downstream systems looking for modified employee -role mapping data. Hence, the expectation is to send the data to our interface(Informatica) in near real time
4. I need to send both old role and new role details. Again, the expectation is to send only the employees for which mapping have been altered
Please guide me. Thanks.