What is complex mapping?

Question

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 1

We have one of the order file requirement. Requirement is every day in source system they will place filename with timestamp in informatica server.

· We have to process the same date file through informatica.

· Source file directory contain older than 30 days files with timestamps.

· For this requirement if I hardcode the timestamp for source file name it will process the same file every day.

· So what I did here is I created $InputFilename for source file name.

· Then I am going to use the parameter file to supply the values to session variables ($InputFilename).

· To update this parameter file I have created one more mapping.

· This mapping will update the parameter file with appended timestamp to file name.

· I make sure to run this parameter file update mapping before my actual mapping.