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

informatica informatica-powercenter
user1021822 picture user1021822 · Dec 4, 2013 · Viewed 8.9k times · Source

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.

Answer

Maciejg picture Maciejg · Dec 4, 2013

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).

Related questions

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I …

Read More
How to dynamically give flat file source file name in session properties of informatica?

i have an issue where i get flat file with date and time extension to flat file name like test_28-10-2012.txt I can get the flat file name in mapping through checking the AddCurrentlyProcessedFileNameproperty in Source Analyzer,from …

Read More
Difference between Joiner and Union Transformation

I'm new to Informatica....What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

Read More