2 Replies Latest reply on Mar 30, 2020 3:07 AM by Mahesh Birajdar

    source table filter using target table date field - IICS

    Mahesh Birajdar New Member

      Hi,

       

      Source table:- Oracle Table

      Target Table:- Azure SQL Server

       

      We have same table structures for tables in both source and target. We are just migrating data from Oracle to Azure SQL.

      Now we cannot use synchronization as we do not have keys and cannot do truncate reload as table contains around 110M records.

      So we will be doing one time full load using Oracle to SQL Server Migration tool and the we need to migrate data incrementally.

       

      Condition we want to use is as below.

       

      while sourcing data from source, we need get data where source.update_date > max(target.updated_date) ..

       

      I am not able to get how to apply this filter.

       

      Any help would be appreciated.

       

      Regards,

      Mahesh