top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Is it possible to get the SQL that would be generated, without running the mapping?

+3 votes
515 views

We can see the SQL's generated by PowerCenter in the session log file once a mapping has been run. So to get these SQLs we have to run the mapping. I would like to know if there is any way to get the SQL that PowerCenter would generate without actually running the mapping, so that we can analyse it, fix it or apply relevant database indexes etc. in case of any issues.

If this is possible then please tell me how.

posted Mar 12, 2014 by Rohini Agarwal

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

1 Answer

0 votes

You can edit the Source Qualifier, go to Properties tab and edit the SQL Query property. There you can see the Generate SQL button that will create the SQL statement. This also works for lookups where you can find the Lookup Sql Override property. Please note that this will not include the source filter (for Lookup).

answer Mar 12, 2014 by Shweta Singh
Similar Questions
+3 votes
Is it possible to get the SQL that would be generated, without running the mapping?

We can see the SQL's generated by PowerCenter in the session log file once a mapping has been run. So to get these SQLs we have to run the mapping. I would like to know if there is any way to get the SQL that PowerCenter would generate without actually running the mapping, so that we can analyse it, fix it or apply relevant database indexes etc. in case of any issues.

If this is possible then please tell me how.

+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?

0 votes
How to copy the data into one excel file at the time of mapping running in informatica?

I want to copy the data into one excel file, while the mapping has been running in informatica.

+2 votes
Is it possible to get the name of previous task from current task in in particular workflow in informatica?

Is there any environment variable which holds the value of task ran ?

...