#DateForumTypeThreadPost
3220 Jan 2014 @ 10:24 PSTDatabaseReplyLarry Higa MacrosYou can get it in T@YS. But they are not updated after version 12
3120 Jan 2014 @ 10:22 PSTGeneralReplydupliacate rowssince it is not a duplicate row, you can use either row_number or rank function to do that
3003 Dec 2013 @ 03:35 PSTGeneralReplyProcess of Change of PI in skewd tableSEL HASHAMP(HASHBUCKET(HASHROW(<PI_Candidate>))) ,COUNT(*) FROM <tablename> GROUP BY 1
2906 Mar 2012 @ 03:20 PSTJobsReplyTeradata FSLDM Hi,   Type of Hire: Full time. We have requirement for Teradata Physical Modeler. If anybody is interesetd, please contact by 04/01/2012 at gotuchintu@yahoo.co.in
2813 Feb 2012 @ 11:15 PSTDatabaseReplyPerformace of Count(Distinct) I would suggest to create a sparse aggregate join index for the query, if possible. That will help a lot
2709 Nov 2011 @ 07:14 PSTDatabaseReplyHigh Skewness Can you please attach the explain plan for the same. It seems that the problem here is happening due to the NOT IN. The skewness seems to be in the spool. In that case I would suggest you to...
2609 Nov 2011 @ 07:05 PSTDatabaseReplyCollect column statistics for a single partition The optimizer goes for a stats extrapolation based on the available histograms. So if the table is not Skewed & have a proper data distribution it will help optimizer to generate a good plan...
2531 Oct 2011 @ 08:36 PDTTrainingReplyTeradata 12 Certification The following books helped me immensely - TE0-121 -> Teradata 12 Certification Study Guide - Basics by Steve Wilmes and Eric Rivard TE0-122 -> Teradata 12 Certification Study Guide -...
2431 Oct 2011 @ 08:20 PDTGeneralReplyProblem with Timestamp in SQL assistant yes..even i hav also obeserved the same thing with SQLA. Try with BTEQ. You will get the exact data.
2331 Oct 2011 @ 08:17 PDTGeneralReplyTeradata Vs ANSI There is avery good chance that the same query will return different results in different modes. ANSI mode has to declared before the login of the session. Following are some of my obsrvaion...
2219 Oct 2010 @ 10:07 PDTGeneralReplyETL jobs hangingDo you have Explain plan for the same.
2115 Oct 2010 @ 04:20 PDTGeneralReplyFailure 2646 No more spool space inCheck for skewness for the Tables...some AMP must highly skewed....remove the skewness...it will resolve that...
2015 Oct 2010 @ 04:14 PDTDatabaseReplyBackup Terminated in the Middle of the way..If your client system or Teradata ARC fails during an archive, you can restart the operation. Teradata ARC responds to the failure by logging all its sessions off the Teradata Database. Because t...
1915 Oct 2010 @ 02:43 PDTUDATopicImplementation of Incremental BackupHere in EIM, the challenge with the backup was backup window was growing steadily. When it reached 11 hour window, it became an issue. With the continuous ETL loads & so many report users it became...
1815 Oct 2010 @ 02:29 PDTUDAReplyTASM Behaviourplease check the TASM settings using schmon -d and then use schmon -M to monitor the resource usage across all the AGs and RPs. That will help you detect how much you are actually using and when
1714 Oct 2010 @ 12:56 PDTUDAReplyRank in Teradataconsider using row_number if you want to generate a unique rank for the data.
1614 Oct 2010 @ 12:34 PDTDatabaseReplyRestrict a user access to certain time windowYou can achieve this with the help of Dynamic Workload Manager. 1> Create user & assign a certain workload c lass, say WD_ConsoleM 2> Go to Dynamic Workload Manager and define periods according ...
1514 Oct 2010 @ 12:14 PDTUDAReplyConverting Hot Standby Node to Active NodeI raised the similar thing to Teradata. We were having 2+1 5500H nodes. Due to IO boundness, I thought of bringing the HSN into configuration. But Teradata was totally against it. The things that y...
1402 Jun 2010 @ 04:35 PDTDatabaseReplySql to delete duplicates in TeradataI tried by creating the same table with UPI on the duplicate columns & loading it with multiload by suppressing the errors.
1307 May 2010 @ 05:06 PDTDatabaseReplyDevising a comprehensive process for "Collect Stats" on the entire EDWThere is a very standard Qry that you can use for getting the stats locking row for access SELECT /*** 64-bit ***/ DatabaseName, TableName, ColumnName, /** Number of columns wit...
1207 May 2010 @ 05:02 PDTDatabaseReplyjob in teradata..may be you can use MLOAD. through MLOAD you can load upto 5 tables at a time.
1107 May 2010 @ 05:00 PDTDatabaseReplyHow to compare data from tables in Teradata with tables in Oraclehow we did is, we divided all the tables into two groups - small tables and big tables. Then we created a Shell script to pull data from oracle & Teradata and match it. For small table entire data ...
1030 Apr 2010 @ 01:47 PDTDatabaseReplyDiagnostic Commands in Teradata..DIAGNOSTIC commands does not give you the correct picture always. You have to check by yourself if collecting stats on those will help or not, especially for the columns.
930 Apr 2010 @ 01:42 PDTDatabaseReplyExplain PlanIf one of the table is very small, say 100 rows, and the other table is very big, say 100 million rows, the optimizer can go for a product join and for them that's the best plan. If you are having ...
830 Apr 2010 @ 01:37 PDTDatabaseReplyResusgaes TableIt is a Node Resource Usage Table. The following command will start logging of all the tables goto Operator Console in Teradata Manager and type the following set logtable all on set re...

Pages