Hi
The context configuration file stores the default value of context variable, the values are loaded before the job execution, if you want to load the value on the fly, you can use
tContextLoad to load the variable value from a general properties file at the beginning of job.
Shong
Yes you can populate the context parameters values from file using tContextLoad component.
Also, you can pass the path of the config file from which the parameters will be populated at run time.
You can do this by passing the path of the config file to the job using following syntax:
Hi,
Can you guide me how to refer from the properties file in ETL projects at runtime where i have mentioned key/value details used as context parameters while developing.
Normally we create "PROJECT_NAME.properties" file which kept in a directory and that directory put in the classpath. The file has all the respective environment details as key/value (like database, directories info) which we have map in the context parameters while developing...
Its working in some project but not working in one project.
Thanks,
Lijo
Hi Lijo
Use a tFileInputDelimited to read the properties file and link it to tContextLoad, the path of properties file should be an absolute path. I don't understand your mention 'Its working in some project but not working in one project.'.
Shong
