Interested to Buy Any Domain ? << Click Here >> for more details...
What is DTM process?
- 4 Answers
- 21479 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / sumeet lalvani
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 ? | 0 Yes | 0 No |
Answer / swetha
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.
| Is This Answer Correct ? | 0 Yes | 4 No |
How we can use union transformation?
Why we use stored procedure transformation?
Can we use the mapping parameters or variables created in one mapping into another mapping?
Difference between task flow and linear task flow
What is workflow? What are the components of workflow manager?
What is parallel processing in informatica?
How to open an older version of an object in the workspace?
can we have to do changes in session property when we are dynamically generating target files?
Separate from a database, an information bazaar, and an information stockroom?
What is the default source option for update stratgey transformation?
How to jion 2 tables, without using any condition?
What is the Rankindex in Ranktransformation?
Teradata 
