Using XML shredding : Natural keys, SurKeys


Using XML shredding : Natural keys, SurKeys

Hi there,

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

My question:

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