Informatica Session Components Tab: Pre-session and Post-session Command

Pre-Session Command:

We can define Operating System Commands or  programs to be executed before the data loading process (Session Process) starts. Operating System commands or programs can be defined as Reusable Commands (defined in the form of   Command Tasks) or Non-reusable commands (defined with this property directly). Some of the uses of commands or programs can be:

• To enable/disable database users before data loading
• Make backup/copy of target tables so that old data can be restored in case of data loading fails
• To intimate users via Emails about the Data Loading success so that they can start analysis

Note: With this features Informatica provides free hand for any thing to perform before data loading.

Post-Session Command:

Post-session Success Command: Same as pre-session but these commands are executed after the Session is completed successfully.

Post-session Failure Command: Same as pre-session but these commands are executed after the Session is terminated because of some problem.

On Success Email:

We can send Emails using built-in feature of Informatica if Session is successful, if Email servers are configured.

On Failure Email:

We can send Emails using built-in feature of Informatica if Session is not successful, if Email Servers are configured.

Note: Emails can be defined in 'Reusable' or 'Non-reusable' modes.