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

What is informatica metadata and where is it stored?

669


What all join we can perform in LOOKUP transformation?

648


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1777


Why is sorter an active transformation?

759


Explain what are the different versions of informatica?

758






What are the advantages of using informatica as an etl tool over teradata?

663


How do you promote a non-reusable transformation to reusable transformation?

767


What is the difference between a repository server and a powerhouse?

945


What are the transformations that are not supported in mapplet?

682


What is xml source qualifier transformation in informatica?

825


Why filter transformation is an active one?

670


What is the use of target designer?

703


what is $$$$?

1821


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1751


What are the different types of transformation available in informatica.

725