Which is the correct priority of assigning a mapping variable?
A. Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value
B. Session parameter file, workflow parameter file, repository value, declared initial value
C. Repository value, workflow parameter file, pre-session assignment, session parameter file, default value
D. Repository value, declared initial value, default value
Sorry , appearently the correct answer is A.
it’s definitely not C.
correct answer is D
The Order of Execution of Paramater Values in Informatica:
1. Paramaeter File
2. Value Assigned in Pre-Session Variable Assignment
3. Value saved in the Repository
4. Initial Value defined for the variable at declaration level
5. The default value defined by Informatica for the Datatype of the defined variable
Sorry , appearently the correct answer is A.
it’s definitely not C.
The correct answer is C
If you use mapping variables in a session, you can clear any of the variable values saved in the repository by editing the session. When you clear the variable values, the Integration Service uses the values in the parameter file the next time you run a session. If the session does not use a parameter file, the Integration Service uses the values assigned in the pre-session variable assignment. If there are no assigned values, the Integration Service uses the initial values defined in the mapping.
Ref: https://docs.informatica.com/data-integration/powercenter/10-2/advanced-workflow-guide/parameters-and-variables-in-sessions/mapping-parameters-and-variables-in-sessions.html