#DateForumTypeThreadPost
5702 Aug 2013 @ 07:25 PDTToolsReplyTPUMP processOk fine Carlos.. Will do .. thanks for the pointers. cheers!  
5601 Aug 2013 @ 09:24 PDTToolsReplyTPUMP processOK carlos.. But still if we use the LOGGING Errors Clause, it would just capture the errocodes, our requirement is to capture the complete copy of the errorneous records and build the views on top...
5530 Jul 2013 @ 10:05 PDTGeneralReplyHow would you access the table when simultanous loading is going on GRANT select/insert/update/delete  on <dbname>/<object_nm.  to USer1,User2;
5430 Jul 2013 @ 09:54 PDTToolsReplyTPUMP processHi Dieter/Carlos, Your opinions on the above pls.. cheers! Nishant
5328 Jul 2013 @ 04:18 PDTToolsReplyTPUMP processhi Experts, any suggestions on above ? cheers
5227 Jul 2013 @ 03:56 PDTGeneralReplyHow would you access the table when simultanous loading is going on Hi Atul, One way of accessing is through --> Locking row for access select * from tab_nm; but this would be a dirty read hence there wont be any data consistency. I hope u were asking the sa...
5126 Jul 2013 @ 09:18 PDTToolsTopicTPUMP process Hi all,   Can you please comment on the implementation/solutions of the below requirements-->   this is our current  process-->   1)we get some ...
5017 Jul 2013 @ 09:46 PDTDatabaseReplyDifference between Application RI,Batch RI,explicit & standard RI?thanks Fred !
4917 Jul 2013 @ 08:55 PDTDatabaseReplyDifference between Application RI,Batch RI,explicit & standard RI?Thanks Fred for your response!. Can you please explain about explicit and application RI as well?   cheers! Nishant
4815 Jul 2013 @ 10:26 PDTDatabaseReplyComposite Secondary Index-thanks Jeff for the quick reply.. In case the col_a and col_b are highly selective then do we go for composite index on (col_A,co_b)? also why do we call it a covered query? are there are some sc...
4715 Jul 2013 @ 08:57 PDTDatabaseTopicComposite Secondary Index-Hi Experts, We have a query which summarise the data based on 2 column col_A and col_b of a table .. if we decide to create Secondary Indexes on col_a and col_B then individual SI's on col_A ...
4614 Jul 2013 @ 04:46 PDTDatabaseTopicDifference between Application RI,Batch RI,explicit & standard RI? Hi Experts,   As we have various types of RI in teradata like Soft RI,application RI ,Batch RI,Explicit RI, Standard RI..   I know that  Soft RI  allows the O...
4512 Jul 2013 @ 10:50 PDTToolsReplyTPUMP for Active Ware housing Hi Experts, Any comments/suggestions on the above pls.. Cheers! Nishant
4411 Jul 2013 @ 09:48 PDTUDAReplyVARCHAR fieldsthanks dieter for the very useful info... Just want to add one point here regarding the choice of char vs varchar that if the length of the string is less than 10 chars then we sould use char and...
4311 Jul 2013 @ 07:41 PDTDatabaseReplyOCES-3 details-Hi All, Any pointers for the above pls..? Cheers! Nishant
4210 Jul 2013 @ 09:21 PDTGeneralReplySet up of Standard Archive & Purge main frame Jobs in teradata?Hi experts, any comments on above..?   cheers!
4110 Jul 2013 @ 09:19 PDTDatabaseTopicPerformance tuning for a tpump script-Hi Experts, There is a tpump which is taking 10 hours to process 7000 records, whcih earlier was taking 1 hour..  not sure why its taking  so long now. the script cotains the normal ins...
4010 Jul 2013 @ 09:11 PDTDatabaseTopicHow to calculate space taken by a volatile table? Hi Experts, I was having a discussion with one of my peer regarding the table size calculation for a VT.   As VT is not stored in any of the Db and is local to user which is currently ...
3929 Jun 2013 @ 12:20 PDTDatabaseTopicOCES-3 details-Hi Experts, I am bit unclear about the OCES-3 (Optimizer Cost Estimation Subsystem version 3) in the stats area  and BMSMS (bit map set manipulation set) in the Query execution. Can any...
3828 Jun 2013 @ 08:27 PDTDatabaseReplyImplicit conversion of Integer to VARCHARHi Ulrich, In context to the above explain plan, i can see both ALL -amps retreival and a group amp operation in it. Would it be considered a group amp or all amp operation? Just asking this as ...
3727 Jun 2013 @ 08:27 PDTDatabaseReplySpace consumed by Primary IndexThanks Vlad for your response.. I belive that its size wont be fixed , the size of the Subtable is going to grow based on the data in main table. for the tables which are currently in development...
3618 Jun 2013 @ 08:11 PDTGeneralTopicSet up of Standard Archive & Purge main frame Jobs in teradata? Hi all, Can any one pls share any doc or case study or if some one can explain the process how to set up the standard archive & Purge main frame jobs in teradata ? thanks! cheers! Nis...
3501 Jun 2013 @ 10:24 PDTDatabaseReplyWill the STATS be useful on below kind of data?Hi , Stats would always be helpful to Optimizer as it gives the data Demographics i.e Unique values,nullabity,non nullabity in order to create the best plae time . Sampled stats are recommended w...
3401 Jun 2013 @ 09:47 PDTToolsReplyHow to exit a BTEQ in shell script? Hi Sachin,   Use  QUIT after LOGOFF, pls find the below difference-     LOGOFF End the current session or sessions, but do not exit BTEQ   ...
3328 May 2013 @ 07:39 PDTDatabaseTopicTypes of locks during Fastload abort-?Hi All, Have a doubt in my mind, just want to clear it regarding the types of locks applied during fast  load abort case and why is it different from that of multiload normally based on the ...

Pages