How to run dynamic queries in Informatica cloud mapping task?

Question

I am new in informatica cloud. I have list of queries ready in my table. Like below.

Now I want to take one by one query from this table which work as a source query and whatever results return which I need to load into target. All tables were already created in source and target.

I just need to copy the data based on dynamic queries which kept in my one of sql tables.

If anyone have any idea then please share your toughs with me. It great helps to me.

Answer 1

The source connection will be the connector to your source database and the Source Type will be query. From there it depends how you are managing your variables. See thread on Informatica Network for links to multiple examples.

Answer 2

Read the table like normally you would do in the cloud. Then pass each of the record into the sql transformation for execution. configure where the sql transformation has to execute and it will run the queries in the database you want.

Answer 3

you can use a SQL task to run dynamic SQL queries.

link to using SQL task approach: https://www.datastackpros.com/2019/12/informatica-cloud-incremental-load_14.html