Parameterizing a tOracleInput component using Talend

Question

I am working on a Job in which I have a tOracleInput and a tFileOutputDelimited component. I want to filter the incoming data which I think can be done using a “WHERE” clause but my problem is I also have to pass the filtered data as an argument for the remote execution of the job as Jar files. Also, I need to name my output file same as the first argument passed during execution.

Please do share your ideas and suggestions on this.

Answer 1

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';

Hope this helps!

To know more about Talend, join Talend for big data certification training today.

Thanks.