Can some one pls suggest whats the best possible way to compare the XML data and relational table data on Teradata DB
(DB Version : 14.0).
I had to start off with one such thing very soon and looking forward for a quick & reliable solution. Thanks in advance !!
I faced similar situation.
Either generate XML separately from tha table using your own code and compare both the XMLs OR load the XML into teradata and comapre the tables.
Do let me know, if you find any better solution.