Hello Mahesh, You can use Synchronization tasks to do in IICS and you have Task operation to do the call based on the source records.You have options for lookup and expressions in the task: Detailed documentation below: https://docs.informatica.com/integration-cloud/cloud-data-integration/current-version/tasks/synchronization-tasks.html
Using Synchronization task, having replication task behaviour is not straight forward. The input operation (Insert, Delete, Upsert, Update) is based on the input record. In delete scenario, you have a record in Target which is not there in Souce and that's needs to be deleted. This can't be handled out of the box by Synchronization task. Few possibles solutions are
--> Input operation is upsert. Keep audit columns in the target. So expectation is all the source records would be either updated or inserted into target. Using PostSQL command, delete the records from Target whose Audit log is not updated.
--> Using a temp table in between Source and Target. Oracle to Azure Temp and then Azure temp to Azure.
Please check and let's know how it goes!
Thanks for reply.
I am fairly new to Informatica Cloud. I have question related to "Keep audit columns in the target.".
Are these tables provided by IC or i need create them manually.
Thanks in advance.
Audit columns are like CreatedBy,CreatedDate,LastModBy,LastModifiedDate, etc and they have to be created manually in your target and have to updated accordingly either from the source or in between thru Informatica while loading the target.