hemasundarnalco

 Profile Answers by 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

sreedhark26

 Profile Answers by 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.

vizaik

 Profile Answers by 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