Passing DSN,userid password dynamically to the oracle stage.

sivasankarie · Post by **sivasankarie** » Thu Sep 14, 2006 1:09 am

I need to connect to different schemas present within a database.I have a sequential file which has the set of instance name,their userid and password.I must fetch the data at runtime and connect to the database.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 14, 2006 2:40 am

Welcome aboard. :D

You must construct a job sequence that reads the file in question and uses the data contained therein to provide values to job parameters of the job that contains an Oracle stage.