In my job, I have tFileInputDelimited which loads the context variables. The file is located in my local directory.
How can I configure the path dynamically so that when I run the build using batch file through command prompt, I can pass the tFileInputDelimited dynamically. I am doing this because I will be running the build in target server.
How can I give relative path to tFileInputDelimited, so that it can read the file from same directory?
Solved! Go to Solution.
I have used context variable of type File with prompt and configured in the File name/Stream of the tFileInputDelimited.
When I run the job through Talend Open Source, I get the prompt to select the file from my directory. How can I pass the path when I run the batch file?
I copied the tFileInputDelimited file in same location of the batch file and passed with batch execution but getting file not found error for the file whose path is present in the input file then setting it to context variable.
Many thanks for the solution @TRF .
I also did something similar to solve the problem. I removed the tfileinput and contextload from my job. Now I just have my context variables. After I build the job, i navigate to the context/Default.properties and added the value of my context variables. I checked when I ran the build, it was showing the context=Default
That way I am able to pass my variable values.
I will use your solution to implement using implicit tContextLoad in my job.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks