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?
Handling static params with ETL appn.
Moderators: chulett, rschirm, roy
Handling static params with ETL appn.
Thanks with regards,
videsh.
videsh.
Re: Handling static params with ETL appn.
No time for a proper answer, but wanted to point out that no 'job modifications' would be involved in this. You simply need to use the 'Set Defaults' option from the 'Job' menu in Director to override the default value of the parameter.videsh77 wrote:Modifying jobs in Sys Test is BIG NO.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You can switch your standard job parameters into project specific job parameters by exporting your development file to a dsx export file and running various search and replace commands on parameter names. I discussed these type of parameters in detail in DataStage tip: using job parameters without losing your mind. You can also use the copy parameter utility from Ken Bland that I described in hacking job parameters. This lets you switch across from job parameters to project specific parameter quickly but you would still need to modify all jobs to add the $ to stage property fields or use search and replace on an export file.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: