#DateForumTypeThreadPost
1328 Feb 2012 @ 01:25 PSTDatabaseReplydelete xxx rows with teradata Carlos - I agree with you in this case,however i didn mean to use the RANK function in the WHERE clause.
1227 Feb 2012 @ 10:57 PSTDatabaseReplyEntity-Relation Model for Teradata Query During the data modelling process, the RI  i.e the primary and foriegn key relations are defined based on the business requirement and this process is called the LDM(Logical data model).Thi...
1127 Feb 2012 @ 10:40 PSTDatabaseReplydelete xxx rows with teradata Hi You can also use RANK function to fetch the first 10 records from the table for deletion
1023 Feb 2012 @ 11:26 PSTDatabaseReplyCollect Stats The purpose of the COLLECT STATISTICS is to gather and store demographic data for one or more columns or indices of a table or join index. This process computes a statistical profile of the...
922 Feb 2012 @ 08:34 PSTToolsReplyLocatio of output file In Mainframe system you can export the data to a PS file by invoking the FXPORT utility.This also requires another step in the same JCL to invoke the XCOM utility which shall transfer the mainfr...
822 Feb 2012 @ 01:22 PSTGeneralReplypermanent space availability,space,permanent space A database without PERM space can not store tables,however it can store views & Macros because they are physically stored in the data dictionary PERM space. Stalin
722 Feb 2012 @ 12:34 PSTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums! Hi Siva - Grant CREATE access to the user ID to carry out the operation in that database. Stalin
622 Feb 2012 @ 12:16 PSTGeneralReplyWhich is better GROUP BY, DISTINCT or SET table It again depends on the number of rows per value present in the table. GROUPBY can be used if the table contains more duplicate rows per value and DISTINCT incase of less duplicate rows per ...
521 Feb 2012 @ 10:39 PSTGeneralReplyPerformance comparision between two teradata DBs Try running the reports in user window i.e out of critical batch window in production..Also check for the workload this reports are running in.... Stalin
421 Feb 2012 @ 10:11 PSTUDAReplyCollect stats in ETL You can also collect stats by calling the procedure in the scripts which would also require an one time entry of the DB and tablename into the procedure view name. Stalin  
317 Feb 2012 @ 12:25 PSTDatabaseReplyCopy/Backup Teradata Tables The table transfer can be also done through NPARC utility.Please check..... Stalin
216 Feb 2012 @ 11:09 PSTDatabaseReplySignificance of MaxLength column Integer data type requires 4 bytes.The data value range is from -2,147,483,648 to 2,147,483,647 Stalin
116 Feb 2012 @ 02:43 PSTToolsReplyusage of check point in fastload At each check point there will be an entry made in SYSADMIN.FASTLOG table.In your case the fast load will resume loading from the first row following the last successful check point(50,000)...

Pages