Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Jan 2012 @ 22:21:20 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Delete and Insert based on Load flag
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, January 03, 2012 16:40 -->


We have loaded journals through Informatica into our Load area. Now we need to Delete or Insert the Target table based on Load data flag sequentially.

We have only two flags..."D" (For Delete) and "I" (For Insert). I can't delete all the records and Insert the records due to Data Integrity issue,

I want SQL like

     Case When flag="d" then

     Delete from tablea where columna=tableb.columna

     When flag="I" then

     Insert into tablea values from Table B


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