i have requirement like this
xml input stage----->xml transformer stage------>odbc stage
what kind of parameters i have to set for these stages to work.
how to read xml file into oracle database
Moderators: chulett, rschirm, roy
If your requirement is it read XML files and load them into Oracle, then your job would look more like:
Folder --> XML Input --> OCI (or ODBC)
With maybe a transformer between the XML and OCI/ODBC stages. As a general rule of thumb, you should parameterize anything in these stages that could change from run to run or environment to environment. Things like:
XML source directory
XML file pattern
Oracle DSN
Oracle Userid
Oracle Password
...come immediately to mind. However, none of them need to be parameters to get this to work. You could hard-code everthing, it's just not a good idea.
Folder --> XML Input --> OCI (or ODBC)
With maybe a transformer between the XML and OCI/ODBC stages. As a general rule of thumb, you should parameterize anything in these stages that could change from run to run or environment to environment. Things like:
XML source directory
XML file pattern
Oracle DSN
Oracle Userid
Oracle Password
...come immediately to mind. However, none of them need to be parameters to get this to work. You could hard-code everthing, it's just not a good idea.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers