MithunK wrote:I bet that one or more people thought that xml blob was a really clever idea when they first did it. :)
In my current assignment we are planning to migrate data from Db2 to Oracle. Currently the data is stored in the form of a XML blob in DB2. However we have designed a relation data model in Oracle to store the same data (which was stored as a XML blob in DB2).
1. Use an ETL tool. My company has Ab Initio license, so I can use this ETL tool.[I do not have experience, but will be eager to learn].I suspect it depends on