Why Unconnected Lookup cannot be dynamic?
November 2, 2017
Four Pillars of Data Quality Management
The Four Pillars of Data Quality Management
November 14, 2017
Show all

Can we define the same port as variable and output port in Expression transformation?

No, that is not possible. At any point of time you can make a port either as an input/output or output or variable only.

If you have a variable, you can define an output port and call the variable.

EMP_FIRST_NAME (INPUT/OUTPUT)

EMP_LAST_NAME (INPUT/OUTPUT)

V_EMP_NAME (VARIABLE PORT) = EMP_FIRST_NAME​||EMP_LAST_NAME​

O_EMP_NAME (OUTPUT PORT) = V_EMP_NAME

Well, you can ask a questions now about defining the concatenation in the output directly. Yes, you can. That is the reason, Variable port is used for any derivations which is needed for more than one time with in the same expression.

A port which can store the data temporarily is know as the variable port, which is represented as (V). A variable port is required to “simplify the complex expression” it improves the performance of calculations. The variable port is  not visible in the “Normal view”, it is visible only in the “edit view”.

For example, if you have to perform validations based on discount % for all the transactions, you can get the discount % from the variable and use it in the output derivations of daily, weekly, monthly sales.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share
+1
Tweet
Pin
Share