Assigning Values to Variables in Matillion
Could you please let me know if we can achieve the following requirement using a Matillion :
Req: We want to provide the flexibility of changing the variable values at any point of time with out touching the Matillion tool . As touching matillion components just for changing the value of a variable or including new values will need again migration from Dev to Prod through testing phase.
1) Informatica provides the flexibility to read the values from parameter file to variable using WF.Session.Variable and point the corresponding parameter files at workflow level .
Using this we dont have to touch the informatica components , we can change the values in parameter file .
2) Creating a parameter table and the row level data will be values of variables for each Orechestration or Transformation . So that we can update the values at the table level so that its not required to change the values at the Matillion if there is a change or additional values to be included in the variable list.
Please let me know if Matillion provides such component, tried grid level variables but not working as per my requirement.