DSXchange

It is known that an XML reader can be used to process XML but ....

Can DataStage Process Blob file to get information from the blob and put it into a table ....

Explanation of the requirement..

I have Table A, where in one of the column XML is stored as BLOB.. I have to retrieve this XML from the BlOB and get all the information present there and put into a Fact Table..

What kind of 'processing' did you have in mind? Not sure how much information you can get from a BLOB* but you could probably load it like any other LOB. DataStage really isn't the tool for that, however.

* Other than what planet it came from, of course, and why it was here.

Please read this post. In case you find a better approach please don't forget to post it. :D

A search on BLOB returns 47 hits, not counting your post. Suggest you browse through those for inspiration.