#DateForumTypeThreadPost
930 Jun 2014 @ 10:40 PDTToolsReplyTPT load failure - Please suggestHi Steve, Thanks for your responses. I have a general question. When loads for smaller files (upto 80-90 GB) are going through successfully using the same scripts and the same version of...
825 Jun 2014 @ 10:18 PDTToolsReplyTPT load failure - Please suggestHi , Sorry i was out for a couple of weeks and couldn't respond. The teradata client version is 13.0. Platform : AIX We are calling the TPT in a shell script with parameters. We loaded 100s...
705 Jun 2014 @ 10:18 PDTToolsTopicTPT load failure - Please suggestDear Experts, We are facing a failure during loading a file into a table using TPT utility. We loaded files a lot of times successfully but this time, its a very huge file (>100 GB) p...
601 Apr 2014 @ 08:38 PDTToolsTopicTPT - Assigning default values for columns not present in a file via TPT to load a tableHi, I am trying to use TPT utility to load data from a file into a table. I create INPUT, SELECT and INSERT schemas a part of this and it usually loads the file into the table without any issues. ...
510 Dec 2013 @ 09:20 PSTDatabaseTopicDifference between NULL and EmptyHi, Could some one please explain me the exact difference between NULL and Empty values for a field from a database perspective ? I do understand the concept that NULL is absence of a value and em...
413 Sep 2013 @ 06:19 PDTDatabaseReplySelecting duplicate records from a table - Complete record and not just the duplicate keysHi, Ignoring the fact that the tables has NULL values for natural key columns, could you let me know if the logic being used to capture the duplicate records is correct ? Thanks Much!!!
312 Sep 2013 @ 02:59 PDTDatabaseReplySelecting duplicate records from a table - Complete record and not just the duplicate keysYes, that's right. I have verified the data in the table and could see that one or more columns (GR,GI,OE,LOE,OBE,CLD) are having NULL values. Please note that these are not primary index...
212 Sep 2013 @ 01:07 PDTDatabaseReplySelecting duplicate records from a table - Complete record and not just the duplicate keysHi ,   Thanks for your response. Yes, the query is a little overstated and thanks for simplifying it. Please find the complete query that i was running below. I have  total of 15 colum...
112 Sep 2013 @ 08:22 PDTDatabaseTopicSelecting duplicate records from a table - Complete record and not just the duplicate keysHi,   I have a situation where i have duplicate records in my table. This is determined based on a combination of a few natural/business keys. I know the way to identify if there are duplic...