Answer Posted / 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 |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
What is meant by target load plan?
Differentiate between joiner and lookup transformation?
What are the restrictions of union transformation?
Global and Local shortcuts. Advantages.
Separate from a database, an information bazaar, and an information stockroom?
What is dimensional table?
Why is sorter an active transformation?
What do you understand by term role-playing dimension?
What is substr in informatica?
What is target designer and target load order?
how many types of dimensions are available in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
differences between service based and product based?
How to convert multiple rows to single row (multiple columns) in informatica
