I am currently investigating how to use the XML shredding functions of Teradata.
In the documentation, it shows you have to create the target E/R model wherein the shredding output would be written.
I see no surrogate key concept in order to handle the following case
. reading a batch of messages from the Queue
. in the batch some messages are duplicate (as far as PK /FK are concerned) but with different attribute values
Once I have shred the several xml into the target E/R model, how do I relate the parent/childs rows belonging the the same message together
(since I would have several same parent / child relations)?
Thanks for tips
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.