top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is a DTM process in context of Informatica?

+1 vote
405 views
What is a DTM process in context of Informatica?
posted Jul 6, 2015 by Sunil

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

1 Answer

0 votes

A. 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, which is called the master thread. The master thread creates and manages all other threads.

• If we partition a session, the DTM creates a set of threads for each partition to allow concurrent processing.. When Informatica server writes messages to the session log it includes thread type and thread ID.

Following are the types of threads that DTM creates:

Master Thread - Main thread of the DTM process. Creates and manages all other
threads.

Mapping Thread - One Thread to Each Session. Fetches Session and Mapping
Information.

Pre and Post Session Thread - One Thread each to Perform Pre and Post Session
Operations.

Reader Thread - One Thread for Each Partition for Each Source Pipeline.
Writer Thread - One Thread for Each Partition if target exist in the source pipeline
write to the target.

Transformation Thread - One or More Transformation Thread For Each Partition.

Or-

The Integration Service process starts the DTM process to run a session. The DTM process is also known as the pmdtm process. The DTM is the process associated with the session task.

The DTM process performs the following tasks:

Retrieves and validates session information from the repository.

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

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

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

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

Creates the session log.

Validates source and target code pages.

Verifies connection object permissions.

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

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

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

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

Sends post-session email.

answer Jul 7, 2015 by Manikandan J
...