Is it possible to get the SQL to be generated without starting a mapping?

We can see the SQL generated by PowerCenter in the session log file after the mapping. So, in order to get these SQL queries, we need to do a mapping. I would like to know if there is a way to get the SQL that PowerCenter will generate without actually doing the mapping so that we can parse it, fix it, or apply the appropriate database indexes, etc. In case of any problems.

If possible, please tell me.

+4
source share
3 answers

Source Qualifier, SQL Query. SQL, SQL. , Lookup Sql Override. , ( ).

+3

. / . SQL- .

, " ". " " 1 ( ).

+1

I think this is not possible in Informatica PowerCenter.

0
source

All Articles