#DateForumTypeThreadPost
2026 Apr 2015 @ 08:17 PDTData ModelingTopicPhysical Database Design - Selecting primary IndexHi All, I am doing physical Database design in my project. LDM(3rd normal form relation model) is done and I am in the process of selecting primary index for the tables. According to my un...
1917 Feb 2013 @ 10:42 PSTToolsReplyFAILURE 2673 SOURCE PARCEL LENGTH DOES NOT MATCH DATA THAT WAS DEFINEDThanks a lot Carlos and Dieter.The Script is working fine now after removing the headers in flat file   Regards, Vijayshankar
1815 Feb 2013 @ 12:17 PSTToolsReplyFAILURE 2673 SOURCE PARCEL LENGTH DOES NOT MATCH DATA THAT WAS DEFINEDThanks a lot
1714 Feb 2013 @ 03:40 PSTToolsTopicFAILURE 2673 SOURCE PARCEL LENGTH DOES NOT MATCH DATA THAT WAS DEFINEDHi, I am trying to export data from oracle to Teradata.I use the following script to load data to flat file       CONNECT usr_id/pwd SET SPACE 0 SET LINESIZE 300 SET PAGESIZE...
1610 Dec 2012 @ 02:11 PSTData ModelingReplyER model and dimensional modelThanks a lot Barry
1515 Oct 2012 @ 10:17 PDTDatabaseReplyre:RAID AND FALLBACKThanks a lot for the reply
1412 Oct 2012 @ 06:46 PDTDatabaseTopicre:RAID AND FALLBACKHi,   What is the need for having FALLBACK option during creating Tables when we have RAID-1 which has a mirror copy of a disk.doesnt it add overhead and cost? Thanks, Vijayshankar
1310 Oct 2012 @ 04:26 PDTDatabaseReplyre:spool spaceThanks a lot Venky and Aftab
1209 Oct 2012 @ 07:25 PDTDatabaseTopicre:spool spaceWhen i get an error stating 'NO MORE SPOOL SPACE IN USER' what does it mean? My understanding is that spool space is allocated equally across all AMPs and upper limit is defined for an USE...
1127 Sep 2012 @ 03:39 PDTExtensibilityTopicotranslate UDF returns nulls when hexadecimal values are usedHi,  I am using OTRANSLATE UDF to remove control characters.I am using it in the following format OTRANSLATE(COLUMNNAME,'09'XC'0D'XC'20'XC,'|||') I am trying...
1020 Sep 2012 @ 10:09 PDTExtensibilityReplyREGEXP_REPLACEHi Dieter,         I am not a C programmer.Thanks for the link.I will see what I can do. Thanks, Vijayshankar
920 Sep 2012 @ 06:25 PDTExtensibilityReplyREGEXP_REPLACEHi Dieter,       Thanks for the reply.Could you please tell me how to wrap C-implementation of REGEXP_REPLACE in TD UDF.Where can I get C version of REGEXP_REPLACE. Thank...
820 Sep 2012 @ 05:21 PDTExtensibilityReplyREGEXP_REPLACEHi Dieter,             Thanks a lot.I am using 13.0.0.16 version.Can you please tell me why there is no source code for this Function in...
719 Sep 2012 @ 11:41 PDTExtensibilityTopicREGEXP_REPLACEHi,    I am not able to view the source code for regexp_replace using show function when i give SHOW FUNCTION TD_SYSFNLIB.REGEXP_REPLACE i get error stating that 'cannot find find b...
619 Sep 2012 @ 10:16 PDTData ModelingReplyER model and dimensional modelThanks a lot sebastian
518 Sep 2012 @ 04:57 PDTData ModelingTopicER model and dimensional modelHi,   1.Please explain the difference between ER model and dimensional model in a simple manner  2.Is it necessary that tables present in both ER model and Dimensional model should...
410 Sep 2012 @ 12:16 PDTDatabaseReply2616: Numeric overflow occurred During computation Hi Juan,            Found out which column was creating problem?  
306 Sep 2012 @ 11:14 PDTDatabaseReply2616: Numeric overflow occurred During computation Hi,  Please check if the datatypes of columns in source and target match exactly if not use cast()   Thanks, Vijayshankar
204 Sep 2012 @ 06:32 PDTDatabaseTopicproduction data Hi all,        Customer is not giving us production data to analyse citing security concerns.He is giving us only sample data and record count for source a...
131 Aug 2012 @ 04:43 PDTDatabaseTopicfloat data type in teradata I have to do the following transformation Round(sum(column),2)   The datatype of column is float.. Round() function is available in oracle. --How to implement this requi...