Hi everyone,
Just a simple question about the usage of variables in ODI.
I've create a first package where the first step is a "Set Variable" called SF_Flow_Name set up to: PRODUCT_FLOW.
The last step of this package perfoms an' update on a configuration table like this:
UPDATE CONFIG_TABLE
SET FIELD1 = 'A', FIELD2 = 'B'
WHERE FLOWNAME = '#PRODUCT_FLOW'
(Some of the values of Flowname on the config_table are: Product_Flow, Customer_Flow and so on)
My question is:
Because I 've many flows to execute, with the same steps; in each of them I set the flowname variable with the name of the Flow I have to execute
BUT
how can I know that the last step of update recognize exactly the correct flowname in the TableName linked to the variable Product_Flow?
In other words: having just a Set Variable for each flow, set at the start of each of them, it is a global one or it works just in the flow where is in?
I'd like it worked only with the setting of the flow where it put in , in order to avoid problems
May someone suggest me please?