Parameters & variables: Tips - What to study & Where to focus!
There will be 6 questions from this topic. You can go through the below sections in the Informatica PDF document to learn about Parameters & variables.
Designer Guide
Chapter 7: Mapping Parameters andVariables
Advanced Workflow Guide
Chapter 15: Parameters and Variables inSessions
Chapter 16: Parameter Files
What to study & Where to focus
Mapping Parameter
- Basic understandings of Mapping parameter fields
- How to assign expression string as parameter field value (IsExprVar)
- What are the different ways to assign values to a parameter field
- Whats the correct priority of assigning a mapping parameter (The order is very important)
The Integration Service looks for the parameter value in the following order:
1. Value in parameter file
2. Value in pre-session variable assignment
3. Initial value saved in the repository
4. Datatype default value
Mapping Variable
- Basic understandings of Mapping variables
- Understands the start & current values of a mapping variable
- What are the different ways to assign start values
- How the integration service looks for the start value (The order of precedence is very important)
- Mapping variable Datatype and Aggregation Type
- Mapping variable functions
aggregation types:
Count, Max, Min
Variable Functions
Workflow Parameter and Variables
- Assigning Parameter and Variable Values in a Session
- Passing Parameter and Variable Values between Sessions
- How to pass a workflow variable to the mapping?
- Parameter file & its structure
- If both mapping parameter file & workflow parameter file, which one will get precedence?
Need Help? email me!