We have requirement to update the records in the custom table from 3rd party Rest API response.
Rest API returns bulk data like 1000 records.
Instead of updating the target table records directly, We want to parse the 3rd party API response data and load that data into import set staging table and run the transform maps to load the data to store in the actual target table.
How can we achieve this? Your quick responses are highly appreciated.
