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