Database Reference
In-Depth Information
I hate hardcoding - parameters and
variables
When you work on any technology, it is always advised that your code be dynamic. This
means that you should use the hardcoded values as less as possible in your code. It is al-
ways recommended that you use the parameters or the variable in your code so that you can
easily pass these values and don't need to change the code frequently. We will discuss this
concept in more detail in the
Parameters file
section in
Chapter 5
,
Using the Workflow
Manager Screen - Advanced
.
In this section, we will discuss how to use parameters and variables on the PowerCenter
Designer screen.
The value of a variable can change between the session run. The value of a parameter will
remain constant across the session runs. The difference is very minute, so you should
define parameters and variables properly, as per your requirements.
Consider a filter transformation where you have defined the filter condition as
LOCATION='USA'
. As you have used hardcoded values in the filter conditions, it is al-
ways recommended that you pass the value using a parameter or variable.
Follow these steps to use variables or parameters:
1. In the designer, navigate to
Tools
|
Mapping Designer
|
Mapping
|
Parameters
and Variables
, as shown in the following screenshot:
