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
can we override a native sql query within informatica? How do we do it?
Reusable transformation and shortcut differences
How can we store previous session logs?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain what are the different versions of informatica?
Mention some types of transformation?
Define sessions in informatica etl?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is event and what are the tasks related to it?
Explain dynamic target flat file name generation in informatica
Explian the Process of deployment groups in informatica
What do you mean incremental aggregation?
what is informatica metadata?
What are the different transaction levels available in transaction control transformation?
Explain your project of banking domian.