#DateForumTypeThreadPost
82114 Aug 2014 @ 02:45 PDTGeneralReplyPLSQL DeveloperSo far as I know PLSQL developer tool is for Oracle alone. Why dont you send  a note to the tool  customer support if its latest version supports TD too? Other tool like Toad Data Po...
82013 Aug 2014 @ 11:37 PDTTrainingReplyTeradata 14 certificationMy opinion is that , since you are already 12 certified, then you can see ahead and enhance your skillsets yourself with latest features. Loads of information in: http://www.info.teradata.com/...
81913 Aug 2014 @ 09:51 PDTDatabaseReplyDifferent types of Indexes in TeradataTeradata has many indexes such as Primary indexes(unqiue , non unique), Secondary indexes(unqiue , non unique), join indexes, hash indexes,sparse indexes.. rows of tables and indexes are distribut...
81813 Aug 2014 @ 09:38 PDTDatabaseReplySum of Column_B for each distinct Column_A  Does it serve the functioanlity if it is:   select sum(sm) from (select id,exposure sm from tabl1 group by 1,2) a   it brings 2.25  
81713 Aug 2014 @ 11:45 PDTDatabaseReplyDelete duplicate in a single queryYou can also do thus: create table tmp as (select * from abc qualify row_number() over (partition by a,b,c order by a,b,c)=1) with data;
81613 Aug 2014 @ 12:02 PDTGeneralReplyNew Features of Teradata 14 I am not pretty sure the context. However, you can see the features here http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/General_Reference/B035_1098_112A/Chap2.48.001.html...
81511 Aug 2014 @ 09:34 PDTDatabaseReplyPartition effectiveness   This is my opinion. I make partition to achieve speed and a goal: I will count the partitions. This is just example: SELECT RANGE_N( EFF_END_DT  BETWEEN DATE '2012-12-31&...
81410 Aug 2014 @ 10:41 PDTDatabaseReplyNumeric overflow issueWith col1 and col2 precisions , given , it works fine when  I do  insert into target select col1,col2 from source; Btw, casting decimal to integer, means losing precision. It may not be...
81309 Aug 2014 @ 03:08 PDTToolsReplyFASTEXPORT LoopingIF ELSE is conditional statement. You read the line thus: In the following example, the user has created the table named &TABLE and a variable named CREATERC, into which is set the syst...
81208 Aug 2014 @ 11:51 PDTDatabaseReplyNumeric overflow issueCheck once again the precision. If you can share the source and its data type and the target and its datatype. To avoid re-work, I am posting a reference of the past posts of our friends here. It ...
81108 Aug 2014 @ 10:17 PDTTrainingReplyRegarding Certification Exams - Pass %You can go for an exam. You can get loads of materials like : http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/  
81008 Aug 2014 @ 10:07 PDTDatabaseReplyDelete from table allFor large number of rows, mload delete is faster. For deleting some rows, bteq can be faster.
80908 Aug 2014 @ 09:35 PDTDatabaseReplyCreating a Soft RII am not sure about your real question. But when you deal with DDL. In bteq, too you create table . 
80807 Aug 2014 @ 06:21 PDTGeneralReplyTeradata UtilitiesFor a small amount of data, the time difference maybe insignificant. For a huge amount of data, loading of empty table will be faster, hoping no issue like network, peak time... 
80707 Aug 2014 @ 03:12 PDTTrainingReplyNeed Teradata TE0-123 Physical implementation materials and dumps.I have met many Teradata certified and found really incompatible in the job. I feel that signing agreement is not enough. Doing justice for the work is important side by side with the certification...
80605 Aug 2014 @ 08:28 PDTGeneralReplyTeradata UtilitiesYou can check the size of your delta and incremental. Unless a major change in the source happens, delta is smaller.
80504 Aug 2014 @ 08:21 PDTDatabaseReplywhat is mean by NO CONFIDENCE in teradataYou can have a look at the documentation in SQL Request and Transaction Processing.   Good read:   Confidence Levels For Single Table Retrieval Operations, Confidence Le...
80403 Aug 2014 @ 08:35 PDTDatabaseReplyTerminal Window Closed AccidentallyCan you check the process (id) in your box? 
80331 Jul 2014 @ 08:10 PDTTrainingReplyWhere can I get the Advanced Teradata SQL pdf documentI am not sure about this course. You can contact TD directly. I can see this link. http://in.teradata.com/TEN/?LangType=16393&LangSelect=true At the bottom we can see " Contact us" ...
80231 Jul 2014 @ 09:01 PDTGeneralReplyReferential Integrity in TPUMP Referential integrity is allowed and good  in tpump, even triggers.   Additional info from the document about tpump. In contrast to MultiLoad, Teradata TPump uses conventio...
80129 Jul 2014 @ 10:25 PDTDatabaseReplyTimestamp FormatI am not Carlos :). It is the same what Carlos has given excepting a dot or bindu. SELECT CAST(CAST(CURRENT_TIMESTAMP(6) AS TIMESTAMP(6) FORMAT 'YYYY-MM-DDbhh.mi.ss.s(6)') AS VARCHAR(26));
80029 Jul 2014 @ 08:42 PDTDatabaseReplyA Sort Table ChangesI thnk you are asking prob_rank is changing. It changes  with data increment or decrement. Maybe I misunderstand your question.
79929 Jul 2014 @ 08:10 PDTDatabaseReplyremove line feed, carriage return from columnWhich version of Td you are using? You can contact your DBA. Companies are driven by policies, NDA, software program downloads etc. :) Maybe you can see few UDFs somewhere like  https://dow...
79829 Jul 2014 @ 07:20 PDTViewpointReplyCreating Different Operating EnvironmentI feel that since business is very important, a proper DRP should be there(preventive,corrective,detective measures), where a DR box takes care of business. Organizations should not mind shelling e...
79729 Jul 2014 @ 03:07 PDTTrainingReplyGood Training Book on InformaticaI feel that you can download a free version of informatica and learn . Reading a book and learn may take time. Lots of materials are also there. Did you check here https://community.informatic...

Pages