#DateForumTypeThreadPost
57110 Feb 2014 @ 09:54 PSTDatabaseReplydynamic index collect stats statementHi, Is this what you are looking for: show table dbc.querystatstbl;----this has pi and si select tdstats.udfconcat(trim(columnname)) from dbc.Indicesv where  databasename='dbc...
57010 Feb 2014 @ 09:00 PSTDatabaseReplyHow do you secure sensitive data from DBAs and IT staff?NDA is (confidentinal) non-disclosure agreeement, signed by two parties( say an employee signed an NDA with the employer) so that few secret things should be respected and not to be divulged outsid...
56907 Feb 2014 @ 07:39 PSTDatabaseReplyConcerning implementing an equivalent of the ORA / DB2 Sequence Object in TeradataHi Karan, Look from the functionality, end requirement. Dont go line by line code . Oracle and some DBs have pseudo cols like nextval, currval etc . Simplify sequence and build a logic if required...
56807 Feb 2014 @ 06:33 PSTGeneralReplyReg. Teradata CertificationHi Venkat, You could have posted under Training forum :). You can follow the link http://forums.teradata.com/forum/training/terdata-certification-in-india Please let me know if it helps. Cheers,
56706 Feb 2014 @ 11:31 PSTToolsReplyBTEQ and the Commit statementDDLs are auto commit. I remember vaguely in one project where I had a unix script , where we switch between btet and ANSI. It was challenging. We segregated the DMLs as per the business requirment....
56606 Feb 2014 @ 10:44 PSTDatabaseReplyTable ID and Table NameYou can join DBC.Dbase,DBC.TVFields,DBC.TVM . Let me know. Cheers,
56506 Feb 2014 @ 08:16 PSTData ModelingReplyFinancial.... LDMNo. I dont have.
56406 Feb 2014 @ 08:14 PSTGeneralReplyTeradata Learning Materials You can get your set up in your system . This link can help you below. http://forums.teradata.com/forum/cloud-computing/vmware-and-td-14-10   If you have worked on oracle in uni...
56306 Feb 2014 @ 08:24 PSTDatabaseReplyIdentifying System Restartselect  * from DBC.Software_Event_LogV where Text like '%Restart%' and then search and sort manually. Please let me know. Cheers,
56205 Feb 2014 @ 09:16 PSTThird Party SoftwareTopicDWH/BI Project Analysis, Estimation,resource tool Is there already any free tool or I need to develop one?   I see a gap of technology, business and people, while working on projects. I am planning to develop or automate the pr...
56105 Feb 2014 @ 08:56 PSTDatabaseReplyHow do you secure sensitive data from DBAs and IT staff?Hi, I think similar to Oracle FAST, Teradata Fast Masking data maybe doing. Maybe you can enquire about this tool. Else you may need to evolve an algorithm , writing your own like substituting tho...
56003 Feb 2014 @ 04:34 PSTToolsReplyTeradata Utility ScriptYou can read the document where os and system commands are used. If you can execute os commands, through that utility, it works. It reminds me of this link before. http://forums.teradata.com/forum...
55902 Feb 2014 @ 08:56 PSTDatabaseReplyNoPIHi, This link may help. http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111A/ch09.050.022.html#ww16471633 There are some more, which describe abo...
55802 Feb 2014 @ 08:27 PSTTrainingReplyTeradata Training and CertificationHi, You can refer to many links under training. http://forums.teradata.com/forum/training/ example : http://forums.teradata.com/forum/training/teradata-developer-training There are onl...
55702 Feb 2014 @ 08:20 PSTExtensibilityReplyGiraph Exports - Best Practices on TeradataHi, This looks interesting. I am about to download the same. Are you planning to take the vertices and graphs too into tables? Read them and load to RDBMS. Regards,
55630 Jan 2014 @ 09:10 PSTDatabaseReplyQuery OptimisationHow many nodes, amps etc your system has? I dont think airport data is so huge. Maybe you can try with exists/not exists in place of <> and see. If data volume is huge , yes partitioning is o...
55529 Jan 2014 @ 11:23 PSTGeneralReplyCAPTCHA CAPTCHA is not friendly :). I have a good eyessight as per my doctor's comment. However, it is strenous for me to recognize. Very rarely, I can get in the first attempt. I think I have solution...
55429 Jan 2014 @ 11:15 PSTDatabaseReplyAggregated Join Index on 2 systemsWith this much info, it is hard to say. It can be due to many reasons,Data  demography,freshness of stats, though they are same etc. Maybe you can share the explain of queries, masking importa...
55329 Jan 2014 @ 11:00 PSTDatabaseReplyFORMAT option in create tableChange this to cust_phone INTEGER FORMAT '999-999-9999',   and let me know. Cheers,  
55229 Jan 2014 @ 04:53 PSTDatabaseReplyhelp in Transpose rows to columnsHi, I am in TD 14 and not in TD 14.10. I have heard about TD_UNPIVOT. It transposes rows to columns. I am not sure whether it transforms columns to rows :). Cheers,  
55129 Jan 2014 @ 04:31 PSTDatabaseReplyNear Real Time Stored Procedure Architecture FrameworkI think that tpump is a better option. I do agree when we use stored procedure in ELT.  Real time and Near real time is a challenge always in my past experience: Ab Initio and SAP DS-- ...
55028 Jan 2014 @ 10:38 PSTToolsReplyARC1900 ErrorHi Kishore, Have a look at this detail: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/General_Reference/B035_1096_111A/ARC.30.293.html Cheers,
54928 Jan 2014 @ 02:59 PSTTrainingReplyTeradata advance training/guidance for certificationThat is one avenue you mentioned :). There are many other facets too like pre-sales, service, post sales etc. But TD is gearing up this year to scale up in many directions, meeting new demands etc....
54828 Jan 2014 @ 02:38 PSTDatabaseReplyGenerate SurrogateKey with a huge tableHi, The third one is discussed in detail with explanation from expert: http://forums.teradata.com/forum/database/best-way-to-generate-the-sequential-numbers-csum-or-identity-columns sequence gen...
54728 Jan 2014 @ 01:37 PSTDatabaseReplyAutomation - Cycle through lookupWith stored procedure, you have more liberty and have more options like branching , if then else, looping...for loop, do while,while ..etc. Also you can stuff things like what Dieter explained. You...

Pages