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

sql teradata informatica informatica-powercenter
Raj V picture Raj V · Jun 26, 2014 · Viewed 7.1k times · Source

SO heres what I am trying to do. I have a table which has 2 columns - QC_Check and Query. For each QC_Check I have a query. There are several records like this.

Is there a way using SQL transformation that, I can fetch the SQL query stored in the Query column to Informatica, run the queries in Teradata and get the results stored somewhere.

Answer

Samik picture Samik · Jun 26, 2014

Although, I have not tried it myself, this should be possible using SQL transformation in Query mode with Dynamic SQL Queries. Use the table with Query column as a source. Create a SQL transformation with Query mode. Connect the Query column to the SQL transformation. enter image description here

Write ~Query_Port~ in the SQL editor in the SQL transformation:

enter image description here

If you want to capture the results from your query, you have to configure output ports for columns you retrieve from the database.

Related questions

SQL SELECT multi-columns INTO multi-variable

I'm converting SQL from Teradata to SQL Server in Teradata, they have the format SELECT col1, col2 FROM table1 INTO @variable1, @variable2 In SQL Server, I found SET @variable1 = ( SELECT col1 FROM table1 ); That only allows a single column/variable …

Read More
What is ROWS UNBOUNDED PRECEDING used for in Teradata?

I am just starting on Teradata and I have come across an Ordered Analytical Function called "Rows unbounded preceding" in Teradata. I tried several sites to learn about the function but all of them uses a complicated example explaining the …

Read More
Find which rows have different values for a given column in Teradata SQL

I am trying to compare two addresses from the same ID to see whether they match. For example: Id Adress Code Address 1 1 123 Main 1 2 123 Main 2 1 456 Wall 2 2 456 Wall 3 1 789 Right 3 2 100 Left I'm just trying to figure out whether the address for each ID …

Read More