#DateForumTypeThreadPost
1812 Mar 2013 @ 03:47 PDTDatabaseReplyMigration of Special Characters of UNICODE to TERADATAThanks for your time. Will try out this option and will let you know the results soon
1708 Mar 2013 @ 12:40 PSTDatabaseReplyEnabling ALC, Pros and consBy default you should be able to create columns with compression. PLease check with your DBA once, he should be helpful to you in resolving it on your TD settings.
1608 Mar 2013 @ 12:36 PSTDatabaseReplyTimestamp format not working to get the two digit yearHi SK RAFI, One of the way to do it using OLAP function. Following query would help you to understand the same. May be you can write a recursive or stored procedure to meet your requirements on ...
1507 Mar 2013 @ 01:18 PSTDatabaseReplyMigration of Special Characters of UNICODE to TERADATAHi Fred, Thanks for your time. The default client character set on our TD machine is LATIN. We have overwritten the value with UNICODE character set during execution of MLOAD loading script. PL...
1406 Mar 2013 @ 02:50 PSTDatabaseTopicMigration of Special Characters of UNICODE to TERADATAHi all, In one of our project, we are facing a challenge to load Special character fields onto Teradata. The source is SQLServer and its character set is UTF16. Though we are able to load the da...
1306 Mar 2013 @ 02:36 PSTDatabaseReplyCrash Code 3701 encountered while creating a volatile tableHi aarsh, In one of the manual i found the following: 3701 Internal error: An unknown error has occurred. Explanation: If this error occurs, an inconsistency was detected by the Teradata Parse...
1206 Mar 2013 @ 02:19 PSTDatabaseReplyHow to update the duplicate records in TeradataHi Siddesh, As commented by rajeev, sample would provide more clarity on your requirement. on a brief note: You can use a self left join to table with left joining table to be a derived table on...
1105 Mar 2013 @ 10:53 PSTDatabaseReplyEnabling ALC, Pros and consSo enabling the ALC will not cause you any impact. But please remember the during application of compression of UNICODE fields. In our project, we faced with data corruption for UNICODE fields up...
1005 Mar 2013 @ 10:51 PSTDatabaseReplyEnabling ALC, Pros and consHi Harish, For the character data type, before Teradata 13.10, MVC (multi value compression) was restricted to fixed-length char┬Čacter columns (CHAR data type) and columns up to 255 characters ...
905 Mar 2013 @ 10:32 PSTDatabaseReplyQuery TuningCan you paste your SQL (insert and select) may be by which dnoeth can provide you much more explanation.
805 Mar 2013 @ 10:02 PSTUDAReplyIssue during Conversion of varchar to Timestamp(0)can you please post sample data
714 Jun 2011 @ 12:30 PDTDatabaseReplyAge CalculationWhile you subtract dates, the functions like day, month and year will return respective values in either days or months or years. In order to solve your problem, why do you nest the funtions; Som...
607 May 2010 @ 06:18 PDTDatabaseReplyjob in teradata..Hi Smithaa, Yes you can use bteq for your tables; I would say BTEQ is the best utility when records are less in number, as it does not have prepartion steps like other load utilities. The syn...
507 May 2010 @ 06:05 PDTDatabaseReplyHow to compare data from tables in Teradata with tables in OracleWhile migrating you might be sticking to plan based on number of days. So you have to collect aggregate level of counts per day per table(for important tables alone) and compare them with teradata ...
403 May 2010 @ 05:35 PDTUDAReplyTIMESTAMPyup sorry i meant "You can not cast improper date values to timestamp in teradata;" in previous phrase
303 May 2010 @ 05:34 PDTUDAReplyTIMESTAMPHi monty, The approached followed by you is not proper. You can cast improper date values to timestamp in teradata; Try running the following query SELECT CASE WHEN TRIM( SUBSTR(T.CREATED...
208 Apr 2010 @ 06:25 PDTDatabaseReplyAggregation is so slow..can anyone help me what i have to do?Hi Lavakumar, Try collecting stats on the columns used in the joins for the tables used and then try running explain again. thanks
108 Apr 2010 @ 05:09 PDTDatabaseReplyHow teradata is using the Composite primary index effectively...?Hi Lavakumar, Teradata uses primary index concept irrespective of number of columns in a same way i.e. to distribute the rows; you can collect stats both at index level or column level if req...