I am trying to load XML file to Oracle. The job finishes without any errors but the file is not loading (it seems as there is no data at XML file - the file is empty). I know for sure that there is data at the file!
I am using the following stages:
Folder->XML Input->Transformer->Oracle OCI.
Will be glad to receive some advice , thanks.
Check that you are NLS-enabled and the folder stage is set to read UTF-8 if the xml file is defined to be utf-8 encoded.
Other way to do it is to set the FileName as input column for the xml stage (In folder stage remember to set the Fully qualified -property to Yes). Then in the xml stage set the input column to include the file path (Input/XML Source-page). This way xml stage does the parsing directly against the file not against the data from folder stage and encoding is handled by xml stage.