#DateForumTypeThreadPost
1421 Sep 2015 @ 09:31 PDTDatabaseTopicTimestamp conversion failingHello All.  We have two tables as below. Both the tables have 1 column COLLECT_DATE_TIME Timestamp(1). 1. DB_DEV.ABCD 2. DB_TEST.ABCD   When I am inserting a value '2015-09-21 21...
1314 Sep 2015 @ 01:36 PDTDatabaseTopicLong time for Insert in Bteq Hello All,   I am doing a simple Select Insert through a Bteq job like below. The count is huge around 500 millions. Insert into target_table (a,b,c) select a,b,c from input_t...
1211 Mar 2015 @ 06:46 PDTToolsTopicMload Update: Records are not getting updatedHello All, I am running a mload job. In the source file, the fields are having different data types like Decimal, Char & Varchar. But when i am running the job, major volume of records are goi...
1124 Feb 2015 @ 10:10 PSTDatabaseTopicMultiload Error Table InterpretationHello Everyone. I was running a MLOAD job from a flat file containing around 1 million rows of data. At the I could see around 10,000 records went into the ET error table. When I am querying th...
1014 Dec 2014 @ 10:03 PSTDatabaseReplyRow Counts of all Tables in a databaseHi Raja, Thanks for the reply. But see, for a table in a particular database, there will be only single entry in the DBC.Tables. Hence Count(*) is not of much use. It wont give the record count&nb...
912 Dec 2014 @ 05:29 PSTToolsReplyTrimming spaces from fieldsHello. I feel simply using "Select Trim(Column) From Table" will give desired result. This will remove leading & trailing blank spaces from the applied column. Thanks
812 Dec 2014 @ 05:11 PSTDatabaseTopicRow Counts of all Tables in a databaseHello All, I faced one scenario where I couldn't find any solution. Let's take an example. 100 Tables are there in a database. How to know the row counts for all the 100 tables in this da...
704 Dec 2014 @ 07:57 PSTDatabaseReplyConnecting Multiple Teradata ServersThanks all for the suggestions. Currently TD 14 we are using. But the TPT utility is not configured for Development purpose. However Ole Load is available. I also tried through this. All seem to be...
620 Nov 2014 @ 09:39 PSTDatabaseTopicConnecting Multiple Teradata ServersHello All.. Greetings of the day..   I have a doubt regarding connecting to multiple TD servers. Till date I have done my works in a particular server, now I need to be involved in 2 serve...
517 Apr 2014 @ 04:48 PDTDatabaseTopicScemantic Layer in Teradata Data WarehouseHi All, Currently we are in development phase of a new data warehouse for a telecom giant according to cLDM 12 data model. Our next plan is to design & build a scemantic layer on top of t...
424 Mar 2014 @ 04:21 PDTDatabaseTopic*** Failure 3156 Request aborted by TDWM. Exception criteria exceeded: AMP CPU Skew, AMP I/O Skew.Hi All,   While inserting records into a target table from source table using Bteq utility, I faced an error message like below, thus aborting the session.  *** Failure 3156 Request ab...
320 Mar 2014 @ 06:47 PDTDatabaseReplyTransaction ABORTed due to Teradata table deadlock in InformaticaKanna, Deadlock only happens when multiple rows with same PI index combinations are there in queue. Because INSERT values lock on a RowHash level. Same PI combination in multple records mean ...
218 Mar 2014 @ 01:30 PDTUDAReplyUsing qualify and group by togetherWhat I found out, I think we cant use Qualify & Group By together. If we are using both, we need to put one in the inner query. Please check below conditions.   --Everything In Select cl...
124 Feb 2014 @ 12:52 PSTDatabaseTopic*** Warning: EOF on INPUT stream.I am executing bteqs from command prompt. I am calling a file at the start which contains credentials (by using .RUN FILE command in the bteq). So whenever I am running the bteqs, its throwing&nb...