#DateForumTypeThreadPost
31205 Aug 2013 @ 11:50 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?If you created the NoPI table from the PI Table the skew will be the same (AMP local). You must create the NoPI table EMPTY and load it from scratch. This should guarantee a good distribution (e.g....
31101 Aug 2013 @ 11:46 PDTToolsReplyTPUMP processDid you actually tried it? Did you read the manuals about the matter, at least? Cheers. Carlos.
31031 Jul 2013 @ 04:50 PDTToolsReplyTPUMP processor 3) Load all the records in the staging table and create ERROR TABLE for the final table capturing the errors in the INSERT SELECT (LOGGING ERRORS clause). Cheers. Carlos.
30931 Jul 2013 @ 04:43 PDTDatabaseReplyLength function counts only trailing spaces in a stringStrange:   BTEQ -- Enter your SQL request or BTEQ command: SELECT LENGTH(' VENKAT ') "Length"; *** Query completed. One row found. One column returned. ***...
30823 Jul 2013 @ 11:54 PDTDatabaseReplyDifference between ANSI and TERA modes with respect to record insertionIt has nothing to do with Transaction mode (TERA/ANSI), It's all about the table definition (SET/MULTISET) Cheers. Carlos.
30723 Jul 2013 @ 11:52 PDTDatabaseReplyprocedure creation error due to a variable that is being referenced.You need to use dinamic SQL to reference the different table(s) that you may get from the DATE SELECT. Cheers. Carlos.
30615 Jul 2013 @ 02:06 PDTDatabaseReplystrtok_split_to_table support only Integer and does not support other data typeHi all. The 'outkey' returned value must be, according to manuals, either INTEGER or VARCHAR(10), but I've found that it can be a VARCHAR up to 32 characters (exceeding this limit, you...
30511 Jul 2013 @ 12:31 PDTDatabaseReplyWhy can we have UPI only when PPI column is part of PIIf the column was not part of the PPI TD should check all and every partition to guarantee unicity, which has a high cost. That's why. (it's in the manuals, BTW) Cheers. Carlos.
30410 Jul 2013 @ 12:30 PDTGeneralReplyNeed to delete the row from the table which is duplicate on entire rowThis has been asked and answered over and over... Your mileage may vary, but in the end you can apply some variations of:    BTEQ -- Enter your SQL request or BTEQ command: SELECT...
30309 Jul 2013 @ 11:43 PDTDatabaseReplyOn Update Current_TimeStampNo 'On Update' feature in TD (it seems more appropriate for OLTP's, not DW's) You may use a TRIGGER instead. HTH Cheers. Carlos.
30209 Jul 2013 @ 02:23 PDTDatabaseReplyNested OREPLACE leads to poor performanceUse oTRANSLATE() instead. HTH Cheers. Carlos.
30108 Jul 2013 @ 06:42 PDTDatabaseReplyteradata partioned primary indexes - how to split and merge partitionsOracle (and SQLServer) implements partitions as dedicated storage ('segments' in Oracle). A table has diferent partitions, which are segments (sort of 'subtables', loosely speaking)...
30008 Jul 2013 @ 12:14 PDTDatabaseReplyFind position of a character in a stringDieter: Agreed, but I was only giving another choice to the OP. I don't know the requirements and varchar sizes, and some people find it hard to deal with recursives... The OP wanted "fi...
29905 Jul 2013 @ 04:28 PDTDatabaseReplyFind position of a character in a stringSorry for jumping in. You can also get the results using an 'iterator' : As per your example (4th ocurrence of  '_':  BTEQ -- Enter your SQL request or BTEQ command: ...
29825 Jun 2013 @ 06:50 PDTDatabaseReplySelecting three words from a stringTwo ways: Classic: Recursive query. New (sort of): Use STRTOK (if there is a max number of 'columns'). HTH. Cheers. Carlos.
29720 Jun 2013 @ 12:19 PDTDatabaseReplyFASTLOAD WITH FIXED WIDTH FILES"I am using Fastload to load some data in to Teradata database from Mainframe"   RTFM: "The SET RECORD command: • Applies only to network-attached systems." &nbs...
29612 Jun 2013 @ 04:46 PDTDatabaseReplyBehavior of VARCHAR and COMPRESSed columns in SPOOLSorry for jumping in. About #1: since 'performance' is something vague in this question, I would add that many client applications calculate the buffers and memory sizes for queries (resul...
29523 May 2013 @ 06:43 PDTDatabaseReplyUsing Table Stats as a userTony: HELP STATISTICS gives you the values that you seem to be interested in. You can query the different tables/views that store the statistics, but you'll need to decipher the 'BYTE'...
29423 May 2013 @ 12:34 PDTToolsReplyMload and Fload ErrlimitRTFM's: Fastload: "The default error limit value is 1000000." Multiload: "The default is no limit." Cheers. Carlos.
29310 May 2013 @ 12:15 PDTData ModelingReplyCan Teradata display the Quarter value of a date?Mark: You can calculate the quarter from dates as ((CAST(EXTRACT(MONTH FROM fecha) AS BYTEINT)-1)/4)+1    BTEQ -- Enter your SQL request or BTEQ command: SELECT DATE, ((CAST(EXTRACT...
29226 Apr 2013 @ 03:40 PDTAsterReplyTeradata Aster: Transfer files from local host to VMYou ought to check the virtual network configuration for your VM. The NAT/BRIDGED/HOST ONLY, ipconfig / ifconfig , masks... It seems to be a VMware issue, not a Teradata one. Cheers. Carlos. &n...
29125 Apr 2013 @ 11:53 PDTAsterReplyTeradata Aster: Transfer files from local host to VMYou can use FTP/SFTP or (maybe better for your needs) enable the 'Shared Folder' option in VMware player. HTH. Cheers. Carlos.
29011 Apr 2013 @ 12:17 PDTDatabaseReplyTeradata DBLinkHi joe. TD14.10 is expected to bring dblinks (sort of). Also, there are some C-written UDFs that can mimic the dblink functionality. Cheers. Carlos.
28911 Apr 2013 @ 12:13 PDTDatabaseReplySession to Node MappingHi again. Adding to the excellent explanation by mr. Nolan, you can have more than one PE per node (as a matter of fact, this is the usual case). Same with gateways. Both are vprocs (software impl...
28810 Apr 2013 @ 07:40 PDTDatabaseReplySession to Node MappingPrakash. You may take a look at Laddered Concurrent Connect (LCC). This seems to be what you are after... HTH. Cheers. Carlos.

Pages