Answered Questions

  • What is Session and Batches?

    Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches...

    Star Read Best Answer

    Editorial / Best Answer

    sanghala  

    • Member Since Apr-2006 | May 14th, 2007


    Session:  A session is a set of commands that describes the server to move data to the target.

    Batch :  A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc..,)

    There are two types of batches in Informatica:

    1. Sequential: When Data moves one after another from source to target it is sequential

    2. Concurrent: When whole data moves simultaneously from source to target it is Concurrent

    ravindra

    • Jul 15th, 2011

    Session is an object of repository,which instructs the informatica server(integration service)to execute the mapping with given database connection's...

  • What is Data Transformation Manager?

    After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is to create and manage threads that carry out the session tasks.· The DTM allocates process memory for the session and divide it into buffers. This is also known as buffer memory. It creates the main thread,...

    Star Read Best Answer

    Editorial / Best Answer

    Goush  

    • Member Since May-2007 | May 15th, 2007


    When the workflow reaches a session, the Integration Service process starts
    the DTM process. The DTM is the process associated with the session and it
    performs the following tasks:


    1. Retrieves and validates session information from the repository.


    2. Performs pushdown optimization when the session is configured for
    pushdown optimization.


    3. Adds partitions to the session when the session is configured for dynamic
    partitioning.


    4. Forms partition groups when the session is configured to run on a grid.


    5. Expands the service process variables, session, and mapping variables and
    parameters.


    6. Creates the session log.


    7. Validates source and target code pages.


    8. Verifies connection object permissions.


    9. Runs pre-session shell commands, stored procedures and SQL.


    10. Sends a request to start worker DTM processes on other nodes when the
    session is configured to run on a grid.


    11. Creates and runs mapping, reader, writer, and transformation threads to
    extract, transform, and load data.


    12. Runs post-session stored procedures, SQL, and shell commands


    13. Sends post-session email.

    chandrarekha

    • Sep 6th, 2007

    Load manager and DTM are the components of Informatica server.  Load manager manages the load on the server by maintaining a queue of sessions and release the session based on first come and firs...