top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is complex mapping?

+1 vote
464 views
What is complex mapping?
posted Mar 9, 2015 by Sachin

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

1 Answer

0 votes

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.

answer Mar 9, 2015 by Manikandan J
Similar Questions
+3 votes

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.

...