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 does update strategy mean, and what are the different option of it?
What are the reusable transformations?
What is the difference between informatica 7.0 and 8.0?
How will the document be delivered to me?
What are the differences between oltp and olap?
Define mapping and session?
What are ETL Tools?
Why do we need informatica?
What all join we can perform in LOOKUP transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Reusable transformation and shortcut differences
what is index?how it can work in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the function of union transformation?
What are the guidelines to be followed while using union transformation?