How to Use a SQL Result As a Parameter In Another Mapping in Informatica Cloud?

Question

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.

Maciejg · Accepted Answer · 2025-03-01 14:23:47Z

1

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.

answered Mar 1 at 14:23

Maciejg

3,3881 gold badge21 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zebediah Jenkins Mar 3 at 18:03

Thanks! I'm so used to passing output values to the next activity in ADF. Your description isn't a new concept, I guess, but certainly a different way of doing things. Thank you!

Collectives™ on Stack Overflow

How to Use a SQL Result As a Parameter In Another Mapping in Informatica Cloud?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related