What is DTM process?

Answer Posted / atiric sofrware(raja)

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.

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is joiner transformation in informatica?

629


Slowly changing dimensions, types and where will you use them

1278


How do you manage the Parameter files while migrating your data from one environment to another environment?

555


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

600


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1635






In informatica workflow manager, how many repositories can be created?

786


What is informatica powercenter repository?

718


Is it possible to use a client with different version than that of its Informatica server?

647


How to create Target definition for flat files?

757


What is the difference between router and filter?

651


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

649


Tell me about Propagate functions in informatica

528


tell me 5 session failure in real time how can you solve that in your project?

1634


Describe expression transformation?

636


What is powercenter on grid?

699