Archives of the TeradataForum
Message Posted: Tue, 11 Jan 2011 @ 09:48:31 GMT
Our dwh is relational and it is in the datamarts where we denormalizate the data.
We keep all the history data in the dwh.
Every row has two dates: beginning and ending of the validity of the data.
When we load the new data into the dwh we check:
- Is it new?
- Is it a modification?
In case of a new register we insert it
In case of a modification we update the ending date of the old register and we insert a new row with the new data.
Until now for doing this we are doing first the update and then in another sentence where we insert the new data.
Notice that a modification bring us to an update and to an insert (not only the update) ?Is there any way to do it in one only step for optimazing times? I was trying to use the merge statement but i think that a row only can be inserted or updated.
Thanks a lot!!!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|