Today we will learn how to create incremental data load (ingestion) in Informatica cloud data integration
- Create two SQL server connections in Informatica cloud administration
- Connection for source database
- Connection for target database
- Create a mapping from Informatica data integration
- Add source
- Select source connection (point to the newly created source connection in the Informatica administration)
- Select source type as query
- In the query window, enter the query to get the maximum timestamp from your target table
- The timestamp should come from the target database table here. This max timestamp will act as a filter to fetch latest records from the source