#DateForumTypeThreadPost
2228 Jul 2016 @ 10:32 PDTDatabaseReplyhow to handle Null values in FASTloadThank you Fred and saeed
2126 Jul 2016 @ 12:50 PDTDatabaseReplyhow to handle Null values in FASTloadSorry for column7 also Nullif only.  
2026 Jul 2016 @ 12:44 PDTDatabaseTopichow to handle Null values in FASTload Define  colum (CHAR(19), nullif='                   '),  colum2 (CHAR(35), nullif=...
1926 Jul 2016 @ 12:37 PDTDatabaseReplyFastload Duplicate Records issuesI got the solution. Thanks for your valueble time.
1820 Jul 2016 @ 01:20 PDTDatabaseReplyFastload Duplicate Records issuesHi CarlosAL Thank you for reply, i checked your command,but i didn't get duplicate records Thanks in advanced
1720 Jul 2016 @ 12:14 PDTDatabaseReplyFastload Duplicate Records issuesHi,   Thnaks for reply, But its production database.
1619 Jul 2016 @ 11:58 PDTDatabaseTopicFastload Duplicate Records issuesHi All,   I am loading data from file to Db using fastload. My file got aborted due to duplciate records,but when i chcecked in file there is no duplicate records in file. I am confusinng.&n...
1513 Jun 2016 @ 12:35 PDTDatabaseReplyHow to Reduce Table Space Hi Carlos, Thank you for Response. Compressoin already there. Thank you, Anil
1412 Jun 2016 @ 11:06 PDTDatabaseTopicHow to Reduce Table Space Hi Experts, One my of Teradata table occupying 2700.25 GB of Space. I did some intial analysis on this table. I have checked everything looks good i.e Primary index (NUPI), Skew everything fine. I...
1312 Oct 2015 @ 08:40 PDTDatabaseReplyIssu With Decimal DatatypeThank you Dieter, It's Working. :) -Anil
1210 Oct 2015 @ 12:44 PDTDatabaseReplyIssu With Decimal DatatypeHi Glass, There is no space in that value.I am unable to round off the value also.am getting error like big value
1109 Oct 2015 @ 10:12 PDTDatabaseTopicIssu With Decimal DatatypeHi All, In my table there is decimal datatype defined as like this decima(30,15). I am getting source data more than defined size like below 0.2999999999999999888977697537484345957636833190917968...
1018 Aug 2015 @ 04:21 PDTDatabaseReplyTable Lock Issue..Hi Nagendra, Thanks for you response.. The thing is , i got the error when i load the data from temp table to target using Insert select format. Thanks Anilkumar  
918 Aug 2015 @ 02:05 PDTDatabaseReplyTable Lock Issue..Suppose if i remove dbname and tablename how it will excute. how it will consider particular table got locked ?
818 Aug 2015 @ 12:04 PDTDatabaseTopicTable Lock Issue..Hi All, I am loading the data from file to temptable using fastload after loading into main table using insert select. After temp table load complete Data got loaded into Main table using Insert s...
707 May 2014 @ 04:59 PDTToolsTopicBTEQ DATA FILEHello All,   I am new to teradata. When i ran the BTEQ script to export the data. It got exported. When i tried to import the same data in the table, the output is different. Please hel...
621 Apr 2014 @ 11:47 PDTDatabaseReplyHow to execute multiple macros in single statment.Thanks Adeel, My req is convert sp in to Macros. I have splited in to 3 macros. I need to execute All three macros in single statement. For example :   If col= 'A '  then exec...
521 Apr 2014 @ 11:41 PDTDatabaseReplyNeed Help on Below Senario ?Hi,   Example : table like this id                base_code 1        &nb...
421 Apr 2014 @ 04:10 PDTDatabaseTopicHow to execute multiple macros in single statment.Hi, I have 3 macros. if  col= 3 then execute first macro(Abc)                      &n...
321 Apr 2014 @ 04:08 PDTDatabaseTopicNeed Help on Below Senario ?Hi, I have column in talbe name as basecode. it contains values 01,02,03,...,99. My req is when i select the basecode='03' then it should come records contains basecode '03' and &#...
215 Apr 2014 @ 06:49 PDTToolsTopicTPT10508: RDBMS error 2583 error in teradata tptHi, I am trying to insert data from prod to dev by using TPT Update operator. By mistake i have deleted all error tables including work table, log table. Agin when i submit the script am got TPT1...
125 Mar 2014 @ 05:53 PDTToolsTopicTeradata TPT Error :: TPT10508: RDBMS error 3812: The positional assignment list has too few values.Hi, When i ran the TPT script i got below error. LOAD_OPERATOR: connecting sessions EXPORT_OPERATOR: connecting sessions LOAD_OPERATOR: preparing target table LOAD_OPERATOR: entering Acquis...