This content has been marked as final. Show 4 replies
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
1. What the tool does
2. How exactly you intend to move it
3. How clean the data really is.
My bet would be that unless the data is sparkling clean and it is basically a one to one mapping that you will need to write code. A hybrid solution might be possible however.