Dear community,
I would like to set up a data pool parameter to allow me to switch between test and prod environment?
So I would need two global variables for my data jobs:
- var_data_source: to allow me switch between test schema and prod schema
- var_table_name: to allow me when creating table to add _test at the end of the table name
I have only found the way to create parameters in EACH data job under transformation and refer to the data pool parameter. Is there a smarter way?
I am still using the data integration (not OCPM).


Thanks a lot!