#DateForumTypeThreadPost
9927 Mar 2014 @ 06:03 PDTDatabaseReplyPopulated zero in decimal field when given space as a valueThanks!!
9826 Mar 2014 @ 05:50 PDTDatabaseReplyPopulated zero in decimal field when given space as a valueCT SAMPLE(ID DECIMAL(5,2)); INS INTO SAMPLE VALUES(' ');   SEL * FROM SAMPLE;
9726 Mar 2014 @ 05:38 PDTDatabaseTopicPopulated zero in decimal field when given space as a valueHi There is a space in my flat file and it's being populated to a decimal field in the target.It inserted as zero.Any pointers on this?
9620 Mar 2014 @ 04:08 PDTDatabaseTopicApplying OLAP functions on hashrow applied columnHi I am using TD13.I am calculating uniqueness fo rows usinhhashrow functions and i need to store that value as varchar in another table to apppky OLAP functions.Since hashrow being BYTE, doe...
9519 Mar 2014 @ 05:05 PDTToolsReplyCode = 2644 No more room in databaseYou can maintain anotehr backup database to hold the tables which were unused for 2 to 3 months and delete from the main database.so that you can able to achive the space in the frequently used dat...
9419 Mar 2014 @ 03:45 PDTDatabaseReplySequence number being resettedThank you Youri.
9318 Mar 2014 @ 06:23 PDTDatabaseTopicSequence number being resettedHi all, I have a table with one of the columns using sequence generator.It is being resetted after somepoint of time.below is the identity column.Is there anythign wrong with the declaration.Thoug...
9210 Mar 2014 @ 08:48 PDTDatabaseReplyCorrecting the corrupted recordIn the simple sens,I need to find the minimum effective date of consecutive duplicates (empno,ename,cod) only. So after first row,it's again the third row.So I need to get first as well as thi...
9110 Mar 2014 @ 08:04 PDTDatabaseTopicCorrecting the corrupted recordHi, CT BBC(EMPNO INTEGER,ENAME VARCHAR(10),DW_EFF_DT DATE, DW_EXPR_DT DATE,CURR_IN INTEGER,RCV_IN INTEGER,COD VARCHAR(10),ADD_DT DATE)    INS INTO BBC VALUES(1,'A','2014-...
9028 Feb 2014 @ 09:32 PSTDatabaseTopicUnused Secondary IndexesHi , I have secondary indexes on a few tables which were unused.Tables are of large size (>100 million rows)In that case,how much the impact will be there on the database?
8917 Feb 2014 @ 07:57 PSTDatabaseTopicHashmap Hi  Is there any chance like if the data is huge then the hash map gets filled completely and hashing stops? Regards KVB
8817 Feb 2014 @ 07:44 PSTDatabaseReplyOrder by Operation Where does the Spool resides?
8717 Feb 2014 @ 06:54 PSTDatabaseTopicOrder by Operation Hi    I have a doubt.Suppose If we mention order by clause in SELECT statement.As per the parallelism concept,each AMP does it's unit of work and it sorts it's own data.But at w...
8607 Feb 2014 @ 10:12 PSTDatabaseReplyTable ID and Table NameReally it's a good one! Thank you Raja.
8507 Feb 2014 @ 10:11 PSTToolsReplyBTEQ and the Commit statementI dont think you can do that in Teradata as it is implicit.
8407 Feb 2014 @ 08:48 PSTDatabaseReplyTemporal conceptCan i get help from anyone?
8306 Feb 2014 @ 05:18 PSTDatabaseTopicTemporal conceptHi ,   I am using SCD type 2 in my project.Below is the example of versioning which i maintain. empno ename sal eff_dt  end_dt  curr_in rcv_in 1&nbs...
8230 Jan 2014 @ 01:33 PSTDatabaseReplyhelp in Transpose rows to columnsThank you Dieter.
8128 Jan 2014 @ 09:52 PSTDatabaseTopichelp in Transpose rows to columnsHi All,  I have a requirement. SELECT COLUMNNAME FROM DBC.INDICES WHERE DATABASENAME='DBNAME' AND TABLENAME='TNAME' ORDER BY COLUMNPOSITION The above statement returns the i...
8028 Jan 2014 @ 03:52 PSTDatabaseReplyDeadlocks whenusing Teradata with InformaticaYes.I will look into the details.
7927 Jan 2014 @ 05:02 PSTDatabaseTopicDeadlocks whenusing Teradata with InformaticaHi All, We are using PDO (where all the transformation logic executed on database side)in informatica by creating temporray views.When running multiple flows in Production,we are facing deadlocks....
7823 Jan 2014 @ 11:14 PSTDatabaseReplySQL statements in UNION executes serial or parallelThanks Dieter.I just want to know the background of this UNION and it's got clarified.
7723 Jan 2014 @ 12:55 PSTDatabaseReplySQL statements in UNION executes serial or parallelHi Raja, I understood the explanation.Thanks for that.  Just an analogy explained below. Suppose I want to extract the rows based on 1 to 10000 id's.If a write a single sql statement th...
7622 Jan 2014 @ 10:46 PSTDatabaseTopicSQL statements in UNION executes serial or parallelHi, Does SQL statements in UNION executes serial or parallel?
7519 Jan 2014 @ 11:56 PSTDatabaseReplyInserting into a timestamp(6) columnThank you Dieter.Unfortunately,we are using TD13.

Pages