#DateForumTypeThreadPost
10726 Apr 2016 @ 05:05 PDTToolsTopicProblem during acceesing the function created on the top of the JAR file installed on the databaseHi Tom, We are in process of creating a Java user defined Function and in order to achieve that  we have deployed the JAR File in the database and  creating a function/proce...
10620 Oct 2015 @ 11:04 PDTDatabaseTopicCopying the Tables(having identity columns) with Data from one Db to another DB-Hi all, there is a requirement of copying all the tables with data from one db (may be dev) to another db ( Test) . It can be done as below : a) Utilizing the metadata tables for creating the au...
10519 Apr 2014 @ 10:49 PDTDatabaseReplyPrimary Index on VARCHAR columnThanks Adeel for the respose! Cheers! Nishant
10419 Apr 2014 @ 12:08 PDTGeneralReplyWhen we need to collect stats on tableHi Experts, I was looking into teradata 14 new features from TEN, i found that there is teradata Autocollect stats feature, which takes care of missing/stale stats automatically. Do we need to ac...
10319 Apr 2014 @ 12:02 PDTDatabaseReplyPrimary Index on VARCHAR columnHi Experts, I have a doubt  just want to clear it.  Generally we tend to make some integer/decimal/numeric column as a primary index & have a tendency to avoid  string columns a...
10218 Apr 2014 @ 07:27 PDTGeneralReplyDifference between Single Table Join Index, NUSI and Hash Index Nice Info.. Thanks Barry & Alison!   Cheers! Nishant
10114 Apr 2014 @ 11:21 PDTDatabaseTopicDaily Increase in Space for Database ?Hi all, As per the some of the requirements , we have to calculate the Daily increase in Volume (bytes) for a database (it includes some 100 + tables) for the past 30 days. One way of doing it is...
10027 Mar 2014 @ 07:33 PDTDatabaseReplyTD questionsHi Experts, Please suggest on above queries . Thanks in advance! Regards, Nishant
9922 Mar 2014 @ 10:43 PDTDatabaseTopicTD questionsHi all, Can you pls suggest on the below?   Which two are considerations for Unicode data and the Teradata Database? (Choose two.) A. Password controls can use the Unicode character set. ...
9814 Mar 2014 @ 10:07 PDTDatabaseTopicSET tablesHi Experts, As i am preparing for certification so wanted that cofirm that Is the below statement true or false  ? I think its false.. SET tables during a MultiLoad are limited to 16 indexes...
9711 Feb 2014 @ 03:29 PSTDatabaseReplyHow Compression WorksOk thanks dieter. Also just wanted to know ,how much savings we get by compressing NULLS or zero length string (i.e '' ) ? I believe NULLS or '' also  take   1 byte...
9611 Feb 2014 @ 01:25 PSTDatabaseReplyHow Compression WorksHi all, Just want to confirm that as the number of values lead to addtion of presence bits which in turn increases to size of table header.  Do we need to go for odd number of values or the ...
9524 Jan 2014 @ 06:35 PSTDatabaseTopicConverions of timestamp to FORMAT 'MM/DD/YYYYBHH:MI:SS'Hi Experts,   I have the below query in whcih i need to compare timestamp value 'YYYY-MM-DDBHH:MI:SS.S(6)  with a date value in format   '01/23/2014 11:53:50.000000&#...
9407 Jan 2014 @ 03:06 PSTDatabaseReplySpecial charcters/XMLthanks Raja for the Reply. but i dont have access to the Teradata admin tool. I just have access to Unix/sql assitant. I tried in Sql assiatnt earlier not in unix.   Cheers! Nishant
9307 Jan 2014 @ 02:49 PSTDatabaseTopicSpecial charcters/XMLHi Experts, Need  ur suggestions in Updating XML string  present in table by first adding 2  column tags in it. for e.g the Table has currently similar data like '<?xml vers...
9222 Dec 2013 @ 06:58 PSTDatabaseReplyDual Systems/fallback/replication?thanks Dieter!
9122 Dec 2013 @ 03:17 PSTDatabaseTopicDual Systems/fallback/replication?Hi all, Requesting your suggestions in answering the below question, which one is the best fit and why --> An application needs replicated data so that one version can be dedicated to the load...
9021 Dec 2013 @ 10:49 PSTDatabaseReplyON and WHERE clause for Joins Hi Gaurav,       a) Yes in the case of Inner Joins--> AND and  WHERE clause are same   b) In the case of Outer Joins AND works with th...
8917 Dec 2013 @ 09:12 PSTDatabaseReplyDifference between NUSI and Hash ordered NUSI?Hi Experts, Any suggestions on the above pls? Cheers! Nishant
8817 Dec 2013 @ 03:52 PSTDatabaseTopicDifference between NUSI and Hash ordered NUSI?Hi all, Need a suggestion on defining  a SI on a column which has very low cardinality (0 or 1 always ). this column would be used in most of the cognos reports. We are thinking of making i...
8716 Dec 2013 @ 10:44 PSTDatabaseReplyUsage of Join indexes?Thanks Khurram.. Just wanted to know , when we would use Bteq to load from staging table to base tables, there is a disadvantage that it would be slower in comprasion of directly loading from Sou...
8616 Dec 2013 @ 05:38 PSTDatabaseReplyUsage of Join indexes?Thanks khurram & Rglass.  so what i got from the above discussion is --> a)  we can load the data from our source files to staging tables  through TTU (mload,fload) ( as th...
8516 Dec 2013 @ 08:43 PSTDatabaseTopicUsage of Join indexes?Hi Experts, As we know that Join Index is helpful in reporting when we have huge tables & complex joins as it avoids the base tables access. But there is limitation that most of the TTUs don...
8410 Dec 2013 @ 04:44 PSTDatabaseTopicUTF -8 or UTF-16?Hi Experts, As per one of the requirement , we are making one column as CHARACTER SET UNICODE CASESPECIFIC. But as we know that in Unicode too we have two types of character sets UTF-8 &...
8302 Dec 2013 @ 09:12 PSTDatabaseReplyDay Of Week or Week-Ending Function?Hi Experts, In addition to the discussion above, I require the calcualtion logic of fin_cal_week , just like we have cal_week in sys_calendar.calendar table for population values in our date...

Pages