Sunday, 10 November 2013

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.




2 comments:

  1. Hi There,

    Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.
    One suggestion from my side: insert Decision Tasks after each session; from the Decision Task there are two output links, one leading to the next session, one leading to the point after all those sessions to be skipped.
    This way you can use simpler conditions everywhere, making them easier to read and to understand.
    That is not strictly necessary, but at least it will make it easier for you to debug and test the link conditions.
    Very useful post !everyone should learn and use it during their learning path.

    Muchas Gracias,
    Afreen

    ReplyDelete
  2. Hi There,


    Nice to be visiting your blog again, it has been months for me. Well this article that I've been waited for so long.

    I will explain my requirement first . I have an Informatica Job which has a mapping variable $$Month Count for which value will be passed through parameter file.

    But, now my client has placed a request like the ETL job should be scheduled three times a month and for each run the $$Month Count values will be 12, 6 and 3.

    Very useful article, if I run into challenges along the way, I will share them here.


    Many Thanks,
    Pranavi

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis