Answer Posted / 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 |
Post New Answer View All Answers
What is joiner transformation in informatica?
Slowly changing dimensions, types and where will you use them
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
In informatica workflow manager, how many repositories can be created?
What is informatica powercenter repository?
Is it possible to use a client with different version than that of its Informatica server?
How to create Target definition for flat files?
What is the difference between router and filter?
Describe the impact of several join conditions and join order in a joiner transformation?
Tell me about Propagate functions in informatica
tell me 5 session failure in real time how can you solve that in your project?
Describe expression transformation?
What is powercenter on grid?