Interested to Buy Any Domain ? << Click Here >> for more details...
What is DTM process?
- 4 Answers
- 21347 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 can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Do you have to change the reject file b4 using reject loader utility.
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
Can you generate reports in Informatcia?
what is mapping override?
what are cost based and rule based approaches and what is the difference?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Teradata 
