Archives of the TeradataForum
Message Posted: Sun, 24 Jul 2005 @ 13:58:35 GMT
I was going thru the UPSERT and MERGE statement documentations. Have the below doubts. experts pls help. Pls correct me if my understanding is incorrect
1. What is the difference between UPSERT (update else insert) and MERGE except that with MERGE, you can insert a row with a different PI than the one mentioned in the ON clause?
2. Why is that you can MERGE only one row at a time?Why is it that the USING clause should only retrun a single row? Cant we use a MERGE statement to process many rows from say staging table to the fact table in one shot. Is one restricted to ML or TPP for such tasks?
Can anyone clarify on the reason for having such restrictions on MERGE? Is it a limitation of TD wrt MERGE. In Oracle, you could process many rows in a single shot using MERGE and the ON does not need to be a PI/Pk (or any index for that matter)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|