Incremental data export to interface (informatica)

Options
RajeshPrabhu
RajeshPrabhu Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Extensibility

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.

 

 

Tagged:

Comments

  • RajeshPrabhu
    RajeshPrabhu Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    Thanks Nathan. Please advice the purpose of time dimension 

    Going by the suggestion just excluding time dimension, Can I not achieve the same result with  3 line items : role , new role and overridden (role <> newrole) boolean. 

     

    In export process

    1. Exports only items where overridden = true. 

    2. Replace role with new role which will eventually reset overridden flag to false for all items and ready for next set of the changes   

Categories