816 Apr 2010 @ 12:12 PDTDatabaseTopicMERGE vs UPSERTwhat is the difference between MERGE and UPSERT? which one of them is supported in Teradata?
708 Apr 2010 @ 04:24 PDTToolsReplySCD type 2In addition to what anandagarwal told, we can also handle SCD type 2 using two other methods: 1) using sarrogate key 2) using version number
631 Mar 2010 @ 07:27 PDTToolsReplyinsert into problem in BTEQthanks it works, i was doing as SELECT :next_var + 1 col2, col3 FROM tableName; but it was using the same value for every row but now i got what the problem was. Thanks anyway
528 Mar 2010 @ 11:34 PDTToolsTopicinsert into problem in BTEQi want to insert some values in my table using INSERT INTO SELECT SQL as: INSERT INTO tableName (col1, col2, col3) SELECT col2, col3 FROM tableName; for col1 i need to pass the value comming...
427 Feb 2010 @ 10:55 PSTDatabaseReplyinsert takes more time than select in TeradataYes because you have a set table and no unique index. If you want to make it SET then there should have a unique index, doing so divert the check on unique index from SET.
326 Feb 2010 @ 06:35 PSTDatabaseReplyinsert takes more time than select in Teradataneed a bit more information.> what are the types of indexes?> stats are collected on which columns?> how many records are there?
222 Feb 2010 @ 05:51 PSTDatabaseTopicunable to logon using CLIi am trying to logon using bteq interactive mode. i did as:.logon myIP/username;password: myPasswordIt connects perfectly.However if i try to connect CLI as:.logon TDPIP/username;password: myPasswo...
119 Feb 2010 @ 03:57 PSTDatabaseReplyCollect Statistics.Statistics provides assistance to optimizer to choose the best plan for execution of the request/query. Without statistics optimizer would not be aware of certain important poimts that should be kn...