Hi all, recently i was asked by the interviewer like,in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value of 70. not with the value of 51.how to do this. if any one knows how to do this pls. reply.thankskumar

Questions by vssaks   answers by vssaks

Showing Answers 1 - 9 of 9 Answers

kishore

  • Jan 29th, 2006
 

u can do onething after running the mapping,, in workflow manager

              start-------->session.

 right clickon the session  u will get a menu, in that go for persistant values, there u will find the last value stored in the repository regarding to mapping variable. then remove it and put ur desired one, run the session... i hope ur task will be done

  Was this answer useful?  Yes

Manisha

  • Feb 1st, 2006
 

U can also define the value of the variable in the parameter file. Power center server serches the value of the variable first in  parameter file then searches for the value stored in repository.

madhu

  • Feb 18th, 2006
 

it takes value of 51 but u can override the saved variable in the repository by defining the value in the parameter file.if there is a parameter file for the mapping variable it uses the value in the parameter file not the value+1 in the repositoryfor example assign the value of the mapping variable as 70.in othere words higher preference is given to the value in the parameter file

raghavendra

  • Mar 4th, 2006
 

mapping parameter represents a constant value that u can define before running session and it returns same value.

mapping variable represents avalue that can change throughout the session.

  Was this answer useful?  Yes

kiran

  • Jun 29th, 2007
 

You can use the built-in function setvarible($$variable_name,($$variable_name+increment_value)) in the condition where you are using the variable.

  Was this answer useful?  Yes

dashingcar

  • Apr 19th, 2010
 

PowerCenter 8.1.1 Performance Tuning Guide
The Integration Service looks for the start value of the Variable in the following order:

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

Use any of the above (preferable parameter file) to change the value

  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