Archives of the TeradataForum
Message Posted: Wed, 05 May 2004 @ 09:18:11 GMT
<-- Anonymously Posted: Tuesday, May 04, 2004 22:24 -->
We too have seen this too. Lots of hours have been spent running around analyzing incoming data and fixing code.
We recently implemented this with a 3rd party, and it works pretty well. We export data to them, with the metadata indicated above. They use our metadata to check our feed.
Then, they turn around and send the data (with some changes) back to us, this time with their own metadata. Our loading process then runs a check against their metadata.
One possible extension of this process, is that the DW loading process could automatically detect any format changes via the source metadata, and ALTER the target model accordingly.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|