Answer Posted / 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 |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
explan ur project architecture?
Explain sessions?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is difference between a gateway node and worker node?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What the difference is between a database, a data warehouse and a data mart?
What is intricate mapping?
Which transformation should we use to normalise the COBOL and relational sources?
What are the features of complex mapping?
What are the different options available for update strategy?
What are the components of workflow manager?
How do you change a non-reusable transformation to reusable transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the status code in stored procedure transformation?