What is Load Manager?

Editorial / Best Answer

Answered by: Deb

  • Jun 8th, 2005


I am providing the answer which I have taken it from Informatica 7.1.1 manual, 
 
Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and carry out workflow tasks.When the PowerCenter Server runs a workflow, the Load Manager performs the following tasks: 
 
1. Locks the workflow and reads workflow properties. 
2. Reads the parameter file and expands workflow variables. 
3. Creates the workflow log file. 
4. Runs workflow tasks. 
5. Distributes sessions to worker servers. 
6. Starts the DTM to run sessions. 
7. Runs sessions from master servers. 
8. Sends post-session email if the DTM terminates abnormally. 
 
When the PowerCenter Server runs a session, the DTM performs the following tasks: 
1. Fetches session and mapping metadata from the repository. 
2. Creates and expands session variables. 
3. Creates the session log file. 
4. Validates session code pages if data code page validation is enabled. Checks query 
conversions if data code page validation is disabled. 
5. Verifies connection object permissions. 
6. Runs pre-session shell commands. 
7. Runs pre-session stored procedures and SQL. 
8. Creates and runs mapping, reader, writer, and transformation threads to extract,transform, and load data. 
9. Runs post-session stored procedures and SQL. 
10. Runs post-session shell commands. 
11. Sends post-session email.

Showing Answers 1 - 4 of 4 Answers

Deb

  • Jun 8th, 2005
 

I am providing the answer which I have taken it from Informatica 7.1.1 manual, 
 
Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and carry out workflow tasks.When the PowerCenter Server runs a workflow, the Load Manager performs the following tasks: 
 
1. Locks the workflow and reads workflow properties. 
2. Reads the parameter file and expands workflow variables. 
3. Creates the workflow log file. 
4. Runs workflow tasks. 
5. Distributes sessions to worker servers. 
6. Starts the DTM to run sessions. 
7. Runs sessions from master servers. 
8. Sends post-session email if the DTM terminates abnormally. 
 
When the PowerCenter Server runs a session, the DTM performs the following tasks: 
1. Fetches session and mapping metadata from the repository. 
2. Creates and expands session variables. 
3. Creates the session log file. 
4. Validates session code pages if data code page validation is enabled. Checks query 
conversions if data code page validation is disabled. 
5. Verifies connection object permissions. 
6. Runs pre-session shell commands. 
7. Runs pre-session stored procedures and SQL. 
8. Creates and runs mapping, reader, writer, and transformation threads to extract,transform, and load data. 
9. Runs post-session stored procedures and SQL. 
10. Runs post-session shell commands. 
11. Sends post-session email.

raju4dw

  • Aug 6th, 2010
 

Load Manager is responsible for dispatching the sessions and maintains Q of sessions based on first in and first out. Load Manager is also known as Master Processor

(DTM) Data Transformation Manager.

DTM modifies the data according to the instructions given in session mapping.  DTM creates 3 virtual stages for each session

1) READER
2) SHARED MEMORY
3) WRITER

Rajendra

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions