I think you should use context variables. You can create two context variables (output_file & where_val ) of “String” type.
Now, in the component tab of the tOracleInput type the below code to concatenate the where clause:
"select * from my_view where field" + context.where_val;"
Next, in the tOutputDelimited component’s name field, you can use the context variable to name your output file:
"/home/user/" + context.out_filename”.
I think these will fulfill your requirements. After this, you can easily access your job remotely. In the terminal, you can type in the command as below:
my_job_launcher.sh --context_param output_file='output.txt' --context_param where_val='>7';