Explain about Informatica server process that how it works relates to mapping variables?

Questions by jvenkateshkumar

Showing Answers 1 - 9 of 9 Answers

hemasundarnalco

  • Mar 9th, 2007
 

informatica primarly uses load manager and data transformation manager(dtm) to perform extracting ,transformation and loading.load manager reads parameters and variables related to session,mapping and server and paases the mapping parameters and variable information to the DTM.DTM uses this information to perform the datamovement from source to target

  Was this answer useful?  Yes

sreedhark26

  • Mar 12th, 2007
 

The PowerCenter Server holds two different values for a mapping variable during a session run:

  • Start value of a mapping variable
  • Current value of a mapping variable
Start Value

The start value is the value of the variable at the start of the session. The start value could be a value defined in the parameter file for the variable, a value saved in the repository from the previous run of the session, a user defined initial value for the variable, or the default value based on the variable datatype. The PowerCenter Server looks for the start value in the following order:

  1. Value in parameter file
  2. Value saved in the repository
  3. Initial value
  4. Default value

Current Value

The current value is the value of the variable as the session progresses. When a session starts, the current value of a variable is the same as the start value. As the session progresses, the PowerCenter Server calculates the current value using a variable function that you set for the variable. Unlike the start value of a mapping variable, the current value can change as the PowerCenter Server evaluates the current value of a variable as each row passes through the mapping.

  Was this answer useful?  Yes

vizaik

  • Mar 24th, 2007
 

First load manager starts the session and it performs verifications and validations about variables and manages post session tasks such as mail. 
then it creates DTM process.
this DTM inturn creates a master thread, which creates remaining threads.
master thread credtes

read thread
write thread
transformation thread
pre and post session thread etc...

Finally DTM hand overs to the load manager after writing into the target

  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