What is DTM process? and What are the different threads in DTM process?

After the load manger performs validations for session, it creates the DTM process.DTM is to create and manage the threads that carry out the session tasks.I creates the master thread. Master thread creates and manages all the other threads.

Types Of  DTM threads :

Master thread: Creates and manages all other threads

Mapping thread: One mapping thread will be creates for each session.Fectchs session and mapping information.

Pre and post session threads: This will be created to perform pre and post session operations.

Reader thread: One thread will be created for each partition of a source. It reads data from source.

Writer thread: It will be created to load data to the target.

Transformation thread: It will be created to transform data. 

Thanks

Ur's Hari

If you like this post, please share it by clicking on g+1 Button.