![]() |
Team,
23 Mar 2016
| 12 comments
,
|
![]() |
I have 2 tables.
16 Mar 2016
| 7 comments
,
|
![]() |
|
![]() |
Hello.
14 Jul 2015
| 1 comment
,
|
![]() |
Hi,
04 Apr 2015
,
|
![]() |
We are doing insert into select from source to back up table.Select part is running fine ,where are when doing insert it is taking time and using high CPU. Based on below parameters and explain,request you to provide suggestion for tuning.
06 Mar 2015
| 2 comments
,
|
![]() |
Folks
09 Oct 2014
,
|
![]() |
So, I'm not sure why this statement isn't working properly. MERGE INTO table1 as a USING table2 as b ON a.date = b.date AND a.id = b.id WHEN MATCHED THEN UPDATE SET col2 = CAST(a.col2 as VARCHAR(3)) ||','|| CAST(b.col2 as VARCHAR(3)) WHEN NOT MATCHED THEN INSERT (id, col2, date) VALUES (b.id, b.col2, b.date);
02 Apr 2014
| 7 comments
,
|
![]() |
Hi all,
08 Dec 2013
| 6 comments
,
|
![]() |
Hello all!
05 Nov 2013
| 4 comments
,
|
![]() |
We are using the SQL MERGE statement as a method to perform straight inserts. When running in Teradata transaction mode, is there a way to detect and log records that do not make it to the target? For example, records that don't get loaded because the target is a SET table and the record already exist or the record violates a USI.
24 Jun 2013
| 2 comments
,
|
![]() |
Is there any way to have a MERGE INTO statement insert rows into 2 separate tables? In the example below, t3 is a work table that will hold the value of :a when the WHEN MATCHED condition is not met. I somehow need to keep track of which values of :a are not matched and result in an inserted row rather than just an update.
04 Jun 2013
| 2 comments
,
|
![]() |
I am using a merge but I'm having a newbie syntax error I think. Here is my statement:
25 Mar 2013
| 2 comments
,
|
![]() |
I need to perfom the simple task of adding new data to a large existing table. My source data is on Teradata and is in a table that looks exactly like my target table (field names, datatype, PI, ...) . For example, I need to add 10 million rows on to a table that already has 800 million rows.
04 Feb 2013
| 2 comments
,
|
![]() |
I have two identical tables. One I treat as stagging (stg) and second as production (pr). I get a daily file which I first fastload into the stg table and then use the merge command to push data over to pr. I only have one same unique key defined on both tables (contact_object_id). Durring the merge sql run I get error message of primary key
19 Dec 2012
| 7 comments
,
|
![]() |
24 Sep 2012
| 5 comments
,
|
![]() |
Recently I encountered an interesting discussion with one of my fellow developer. I have a following scenario:
11 Oct 2011
| 4 comments
,
|
![]() |
Hi All, I am following below topic http://www.teradatamagazine.com/v10n01/Tech2Tech/Another-option-on-the-table/ I have some questions , 1. How I can use MERGE for update query when match is on NON - PI value. My query is like
20 Jun 2011
| 1 comment
,
|