I am trying to create an incremental load for a table that has no created/modified date fields, and no CDC on the source database. Since records are only inserted into this table, I would like to retrieve the max value of the primary key that exists in the target, and pull anything greater than that result. I can use a SQL object in the mapping to get the value, but how do I set a parameter to that value or just pass it to another mapping? Since the Source object can't have an object running before it, it can't be in the same mapping, and I'm not sure how to make it work.
This is my first time working with Informatica--this would be so easy in Azure Data Factory or SAP Data Services.
Use an input-output parameter and set it's value in the first mapping. Next get the value in the Taskflow and pass this as an input parameter to the second mapping.