I have a requirement where I want to do an initial full load to a third party system. And then delta load after that.
Source is SFAPI :- CompoundEmployee API and the filter I am applying to get the latest active record of an employee is "effective_end_date = Current Date". But I get two records for an employee when I applied this filter. Can anyone suggest on this, as I need only the latest active record for an employee.
Thanks & Regards,