teradata - Informatica - How to Pass queries from a table to SQL Transformation and get the results -

teradata - Informatica - How to Pass queries from a table to SQL Transformation and get the results -

so heres trying do. have table has 2 columns - qc_check , query. each qc_check have query. there several records this.

is there way using sql transformation that, can fetch sql query stored in query column informatica, run queries in teradata , results stored somewhere.

although, have not tried myself, should possible using sql transformation in query mode dynamic sql queries. utilize table query column source. create sql transformation query mode. connect query column sql transformation.

write ~query_port~ in sql editor in sql transformation:

if want capture results query, have configure output ports columns retrieve database.

sql teradata informatica informatica-powercenter