Explain what is DTM (Data transformation manager) Process.

1.	Explain what is DTM (Data transformation manager) Process.
Answer» PowerCenter Integration Service (PCIS) started an operating system PROCESS, known as DTM (Data Transformation MANAGER) process or pmdtm process to run sessions. Its primary ROLE is CREATING and managing THREADS responsible for carrying out session tasks. Among the tasks performed by DTM are: Read the session information Form dynamic partitions Create partition groups Validate code pages Run the processing threads Run post-session operations Send post-session email

Answer»

PowerCenter Integration Service (PCIS) started an operating system PROCESS, known as DTM (Data Transformation MANAGER) process or pmdtm process to run sessions. Its primary ROLE is CREATING and managing THREADS responsible for carrying out session tasks. Among the tasks performed by DTM are:

Read the session information
Form dynamic partitions
Create partition groups
Validate code pages
Run the processing threads
Run post-session operations
Send post-session email

Discussion

No Comment Found

Related InterviewSolutions

Explain the dimension.
What do you mean by the star schema?
What is the importance of partitioning a session?
Explain complex mapping and write its features.
What do you mean by incremental loading in Informatica?
What are different types of tasks in informatica?
Describe workflow and write the components of a workflow manager.
Explain what is DTM (Data transformation manager) Process.
Write difference between stop and abort options in workflow monitor.
What is the difference between SQL Override and Lookup Override?

Explain what is DTM (Data transformation manager) Process.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment