This feature would certainly increase effectiveness in troubleshooting transformations of specific fields or variables throughout the ETL process. It will also provide immediate insight in all the steps that a field or variable goes through while developing a (new) data flow in ETL.
The idea?
Trace fields and variables within all of your ETL-steps, e.g, the use in functions (field transforms), filters (table views) and any possible renaming to another field name.
How? For example:
- Select a field in any step of your ETL > right mouse button > choose "trace field" > pop-up with a FlowGraph of all steps that use (mention) the field
- Select a variable in your list of variables > right mouse button > select "trace variable" > pop-up with a FlowGraph of all steps that use (mention) the field
Additionally, it would help when the FlowGraph mentions the function name, rename (new name), filter etc. in which the field or variable is used.
ADMIN RESPONSE
Jul 2, 2019
In Jedox 7.1, the tracking of variables has been implemented.