Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 24 Jul 2005 @ 13:58:35 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   UPSERT Vs MERGE
 
From:   Aananth.S

Hi,

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)


Thanks

Aananth



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023