top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
521 views

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.

posted Jul 9, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Jul 16, 2014 by Shweta Singh
Similar Questions
0 votes
Running SQL against the source in Informatica and exporting results to a target table

Using Informatica designer, is there a way to run a complex SELECT statement as-is against a source database, and workflow it into a target table? For example, SQL Server Integration Services makes it really easy to create source/target connections, paste your source SQL, and map the results to the target table. When the package is run, SQL runs against the source, and results are dumped into the target.

Is something like that available in Informatica?

+1 vote
How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

0 votes
Informatica: How to pass unique values to one table and duplicate values to another one in a single mapping?

Suppose if we have duplicate records in a table temp_n. Now I want to pass unique values to t1 and duplicate values to t2 in single mapping? How can we achieve?

+2 votes
Informatica: how to get the auto-generated primary key of a table in Informatica mapping?

My question is very similar to the one below, but on a informatica environment:

Retrieving the index of an inserted row

Here is a brief summary of the issue: I'm trying to figure out how I can insert a row into a table and then find out what the value of the auto_incremented id column was set to so that I can insert additional data into another table. Our target is SQL server 2008. We have a table which has to be populated by informatica ETLs and the application is also using the same table - so, we can't use informatica sequence generator.

In the past when I have used Oracle database, there was a Oracle sequence generator transformation available in Informatica - but for SQL server, I am not sure.

Any solutions please?

...