Could you please share your ideas on how to extract bulk text data from XML source file (attached document) and load it to a XML target or target DB table.
XML source file contains mainly two fields Author description and Book description which holds large amount of text data of data type Varchar(1024).
I created a simple job 'xml_job' using the below
Source file: Attached xml source file
Transformation : XML_Pipeline
Target: Xml file / Target table
the job (xml_job) is failing.
Please suggest on how to load the data to target and make the job successful.
Quick response appreciated.