Update and Insert on the Same Table

bapajju · Post by **bapajju** » Wed Oct 19, 2005 9:39 pm

Hello,

I have a typical problem. My target is a Teradata Table. I have to Update the Existing records for sertain field and Insert New record for the Corresponding updated record.

In Teradata for Update and Insert link if I put Transaction size more than 1 then the Table gets locked. So the only option is to put transaction size as 1 for Update and Insert link. But this process takes longer time load large amount of data as Transaction size is set to 1.

Is there any simple way that I can Insert and Update multiple rows into Teradat table with More than One Transaction Size.

Thanks
Bapajju

ray.wurlod · Post by **ray.wurlod** » Wed Oct 19, 2005 11:44 pm

Do the inserts and the updates separately. Use a lookup to determine whether the row already exists; choose one of two output links on this basis.
You might even consider directing these links to text files ready for bulk loading into the table.

bapajju · Post by **bapajju** » Thu Oct 20, 2005 7:32 am

Thanks Ray. That's a great idea.

ray.wurlod wrote:Do the inserts and the updates separately. Use a lookup to determine whether the row already exists; choose one of two output links on this basis.
You might even consider directing these links to text files ready for bulk loading into the table.