Handling static params with ETL appn.
Posted: Wed Apr 18, 2007 10:55 am
Hi
If I want use static params for my ETL application, how am I supposed to pick their values using file?
We have developed DS jobs having userid, password, dbname & schema as an individual job parameters in the development. As we will be moving from Dev -> Sys Test, we will have to open each & every job to modify values which will correspond to Sys Test environment. Modifying jobs in Sys Test is BIG NO.
Even if I intend to take these parameters into the PROJDEF, I will have to access them using '$' qualifier within the DS Job. This involves lot of modification.
Isnt there any way, where we can preserve this static info in a file including password with encrypted format.
How can we achieve the same?
If I want use static params for my ETL application, how am I supposed to pick their values using file?
We have developed DS jobs having userid, password, dbname & schema as an individual job parameters in the development. As we will be moving from Dev -> Sys Test, we will have to open each & every job to modify values which will correspond to Sys Test environment. Modifying jobs in Sys Test is BIG NO.
Even if I intend to take these parameters into the PROJDEF, I will have to access them using '$' qualifier within the DS Job. This involves lot of modification.
Isnt there any way, where we can preserve this static info in a file including password with encrypted format.
How can we achieve the same?