What is DTM process?

Answer Posted / gvk

After the loadmanger 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 manges all the other
threads.\
DTM process: The Load Manager creates one DTM process for
each session in the workflow. it performs the following
tasks:

• Reads session information from the repository.
• Expands the server, session, and mapping variables
and
parameters.
• Creates the session log file.
• Validates source and target code pages.
• Verifies connection object permissions.
• Runs pre-session shell commands, stored procedures
and SQL.
• Creates and run 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.


RAja u are wrong

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differences between connected and unconnected lookup?

610


How to load the data from people soft hrm to people soft erm using informatica?

565


What are the tasks that can be performed using sq?

617


Differentiate between a database and data warehouse?

656


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1703






Can we override a native sql query within informatica?

632


What do you mean incremental aggregation?

628


What are the basic requirements to join two sources in a source qualifier transformation using default join?

619


What is powercenter on grid?

699


What is decode in informatica?

663


What do mean by local and global repository?

708


What is a repository? And how to add it in an informatica client?

664


What is session task and command task?

651


Describe the impact of several join conditions and join order in a joiner transformation?

649


Can you generate sequence numbers without using the sequence generator transformation?

604