What is DTM process?
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 to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
update strategy transformation in informatica
I want skip first 5 rows to load in to target? what will be the logic at session level ??
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
What do you understand by a term domain?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
Difference between task flow and linear task flow
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain the difference between mapping parameter and mapping variable?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer