#DateForumTypeThreadPost
2719 Apr 2016 @ 12:01 PDTTeradata ApplicationsReplyHow to replicate the valuesHi Dieter, Can u please explain how can we do it using recursive query.
2617 Apr 2016 @ 09:44 PDTTeradata ApplicationsTopicHow to replicate the values Hi All, I want to Write a query to duplicate each row based on the value in the repeat column? The input table data looks like as below Products, Repeat ---------------- A,  &nb...
2511 Apr 2016 @ 11:22 PDTDatabaseReplyIdentity column question - increment behaviourThat's the limitation of Identity column.after a sequence it will produce random numbers,for getting a sequence better go with a row_number function or a window function
2409 Apr 2016 @ 12:43 PDTTeradata ApplicationsReplyHow to use Loops Please Help me guys !!  
2309 Apr 2016 @ 11:10 PDTTeradata ApplicationsTopicHow to use Loops Hi All , I have my table like this : Id Name Country 1   Vaibhav India 2    Amit     UK 3     Pranav  US   I want t...
2207 Apr 2016 @ 08:51 PDTDatabaseReplyfrom table with daily log to table with from-to datesBetter use a qualifier here
2107 Apr 2016 @ 08:40 PDTDatabaseReplyHow to Add IDENTITY_COLUMN into existing table ?I think the table can be altered Add the column to the last in ddl,or last option is use a qualifier
2003 Apr 2016 @ 03:59 PDTTeradata ApplicationsTopicTeradata Practice SceneriosHi , I want to practice some Query scenerios in teradata,can any one suggest me some blogs or links because i'm not able to find any links with set of good questions.   Cheers...
1928 Mar 2016 @ 12:32 PDTTeradata ApplicationsReplyT-PUMP DML ERRORRemoved,but still the same errors
1826 Mar 2016 @ 07:09 PDTTeradata ApplicationsTopicT-PUMP DML ERROR .LOGTABLE  etlt5.EMP_TPUMP_LOG; .logon ttdbia/LOGIN DETAILS; .BEGIN LOAD; PACK 5 RATE 10 ERROR TABLE Etlt5.TPUMPERROR;  .LAYOUT RECLAYOUT;  .FIELD   ...
1723 Mar 2016 @ 05:47 PDTTeradata ApplicationsReplyTPUMP NOT WORKINGhey guys plz reply on this post :)
1621 Mar 2016 @ 11:06 PDTTeradata ApplicationsReplyTPUMP NOT WORKING@Deiter ,i have edited the script but the same errors i'm facing TPUMP<<eof1 SESSIONS 1; LOGTABLE Etlt5.EMP_TPUMP_LOG; .logon ttdbia/a0c9sx,blue@126; BEGIN LOAD PA...
1520 Mar 2016 @ 04:30 PDTTeradata ApplicationsReplyTPUMP NOT WORKINGCAN any one plz reply??
1420 Mar 2016 @ 01:50 PDTTeradata ApplicationsTopicTPUMP NOT WORKING I have the below code For T-PUMP WHICH IS not working .Please help me because t-pump has very less number of posts online bteq<<eof1 SESSIONS 1; LOGTABLE Etlt5.EMP_TPUMP_LOG; .logon...
1316 Mar 2016 @ 11:39 PDTDatabaseReplyMerge - Without insert when not matched?Here the data from the test table is getting matched multiple times with the other table. Have some unique matches in both the tables .it will solve the issue
1216 Mar 2016 @ 11:03 PDTDatabaseReplyMerge - Without insert when not matched?it's simple.if there will be no match between the tables then NULLS (if allowed) would be getting inserted at those places
1113 Mar 2016 @ 03:50 PDTTeradata ApplicationsReplyM-load Error while executing scriptThanx Dieter :)
1013 Mar 2016 @ 03:18 PDTTeradata ApplicationsReplyM-load Error while executing scriptIT WORKED !!! Thanx  a lot  Dieter i tried with the second option given by you . (mload<multiload.sh ) what this thing exactly means?
913 Mar 2016 @ 01:57 PSTTeradata ApplicationsReplyM-load Error while executing scriptHere my MLOAD Script (mulitload.sh): .LOGTABLE ETLT5.LOG_INFA; .logon ttdbia/a0c9sx,blue@126; .begin import mload tables ETLT5.INFA_SOURCE12 ; .layout InputFile_layout; .field id * varchar(10)...
813 Mar 2016 @ 01:39 PSTTeradata ApplicationsReplyM-load Error while executing scriptThanx Dnoeth, changed my script according to what you have mentioned but stiil facing the same errors.
712 Mar 2016 @ 09:51 PSTTeradata ApplicationsReplyM-load Error while executing scriptPlease help me guys !!
612 Mar 2016 @ 01:12 PSTTeradata ApplicationsTopicM-load Error while executing scriptHi All,   When executing the below script for MLOADm getting the below error:   output: $ ./multiload.sh ./multiload.sh: .LOGTABLE:  not found. ./multiload.sh[2]: .logon:&nb...
506 Mar 2016 @ 10:10 PSTTeradata ApplicationsTopicMultiple sessions in Fastloadi tried making two sessions in fasload 1st got passed with inserion and 2nd didnt showed any such behaviour. so why cant we have multiple sessions in fastload to load multiple tables?
427 Feb 2016 @ 02:14 PSTTeradata ApplicationsTopicHow to see Information In Data Dictionary in teradata after stats collectionsThere are 3 locations. DBC.ColumnStats, DBC.IndexStats, and DBC.MultiColumnStats where the information for the stats used to get stored.i'm giving the below query to find that info regarding no...
322 Feb 2016 @ 12:50 PSTTeradata ApplicationsReplySame ROW-Hash Value for all the recordThanx Fred for your time  :)

Pages