#DateForumTypeThreadPost
902 Feb 2016 @ 11:40 PSTDatabaseTopicincorrect use of subquery error Hi,   The below query is giving error while running in Teradat SQL Assistant.   Error- Incorrect use of subquery TGT_UPD_CNT   Query-   SELECT...
812 Jan 2016 @ 03:57 PSTTeradata ApplicationsReplyMultiple files in Fastload scriptHi, U can easily load the multiple input files into a single table using FASTLOAD. After the .LOGOFF command repeat the loading process, i.e.; define another file for load and so on for other fil...
710 Jan 2016 @ 10:20 PSTTeradata ApplicationsReplyDOT CHARACTER FOR BTEQ, FASTLOAD AND MULTILOAD COMMANDSThe above result is simply a vertical pivot where col2 values are getting concatenated based on the matching col1 values. The below query will give the result: SELECT  X.COL1 ,MAX(CASE WHEN...
608 Jan 2016 @ 11:54 PSTTeradata ApplicationsTopicparllel processing in bteq and fastloadI came to know from Internet materials that Fastload uses sessions to process data in parallel, where bteq works on row by row. But in bteq also we can specify no. of sessions, then bteq should als...
508 Jan 2016 @ 06:49 PSTTeradata ApplicationsReplyDOT CHARACTER FOR BTEQ, FASTLOAD AND MULTILOAD COMMANDSBut in the above statement, for BTEQ is it mentioned that period should be there before bteq commands, otherwise BTEQ will assume as a SQL statement.  That means , period is mandatory for BTE...
408 Jan 2016 @ 04:24 PSTTeradata ApplicationsTopicDOT CHARACTER FOR BTEQ, FASTLOAD AND MULTILOAD COMMANDSHi, I just want to know whether dot character used before bteq , fastload and multiload commands is mandatory or not. I have been searching about it for a past couple of days, but I am getting mi...
305 Aug 2015 @ 08:57 PDTTrainingReplyRegarding Certification Exams - Pass %Hi, Recently I gave teradata 14 basics exam. I haven't received the results yet.  Can anyone tell me what is the exact passing percentage required for Teradata 14 basics exam.
229 Jun 2015 @ 07:32 PDTDatabaseReplyspool space allocationthnks..for the clarification...
128 Jun 2015 @ 04:54 PDTDatabaseTopicspool space allocationI have some doubt on spool space allocation for a particular user on the below scenario:   Suppose user SYSDBA has 500 GB of perm space. It creates user MRKT with 300 GB of perm space and 30...