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 create a node as a gateway node and the same node can be assigned to a grid?
How many numbers of sessions can one group in batches?
difference between repository database and repository service?
How to elaborate tracing level?
What is the cumulative sum and moving sum?
On which transformations you created partitions in your project?
What are the guidelines to be followed while using union transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is pmcmd command?
my source is junk data how will u remove that junk data by using unix please any one replay me
what is size of u r database?
What do mean by local and global repository?
what is $$$$?
What are the components of workflow manager?
In informatics server which files are created during the session rums?
