Archives of the TeradataForum

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

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

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

Hello,

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

Regards

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