Interested to Buy Any Domain ? << Click Here >> for more details...
What is DTM process?
- 4 Answers
- 21468 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 will u pas the data with out debugger?
What is Session and Batches?
What is the session task and command task?
Difference between session variables and workflow variables?
What are data-driven sessions?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
explain about session partitions ?
Can u generate reports in Informatica?
Explain why we use partitioning the session in informatica?
r u done any partitions in ur project?
how to through logic of informatica using the push down optimization into oracle.
what are the types of Data warehousing ?
Teradata 
