INTERVIEW QUESTIONS DATA WAREHOUSING INFORMATICA DETAILS

Question: What is Data Transformation Manager?

Answer: 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.

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. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question