hi Manisha,
yes, we can see them in log files, i.e., what ever we do in informatica designer, that backend SQL code will be seen in log files. These files are created by Power center server, i.e., in server folder, session logs, etc., we can check the code in log files.