Setting Variable Values in a Step FAQS

1. What happens if I don’t overwrite a variable value in a step?
• If you don't overwrite a variable value, the step will inherit the value from its parent step or from the value set when the Load Plan was started. The value will propagate down the step hierarchy unless explicitly overwritten.
2. Can I overwrite variable values for only one step?
• Yes, you can overwrite the variable value for a specific step and its child steps. The change will not affect the parent or sibling steps.
3. What are the options for modifying a variable value in a step?
• You can either set a new value for the variable in the Value field or refresh the variable’s value by selecting Refresh if a refresh query is defined.
4. How does the variable overwrite work across steps?
• When you overwrite a variable at a step, that new value applies to the selected step and all its child steps. The value will remain in effect unless overwritten again in a descendant step. Changes made at this level do not affect sibling or parent steps.
5. Can I refresh a variable’s value in a step?
• Yes, you can refresh a variable's value if it has a Select Query defined for it. The refresh action will update the variable's value before the step executes.
6. Do variable values automatically update if I change the SQL for a Global or Project variable?
• No, changes to the refresh SQL of a Global or Project variable do not automatically update the corresponding Load Plan variable. To update it, you need to manually refresh the variable in the Load Plan using the Refresh Variable Definition option.
7. Can I revert a variable to its original value after I’ve overwritten it?
• Overwriting a variable in a step is a one-time change. If you want to revert to the original value, you’ll need to manually reset the variable or refresh it if a refresh query is available.
8. Is there any way to update the variable refresh SQL automatically?
• No, the variable refresh SQL does not automatically update when changes are made at the Global or Project variable level. You must use the Refresh Variable Definition option to update it manually in the Load Plan editor.