#DateForumTypeThreadPost
67312 Apr 2014 @ 11:12 PDTGeneralReplyStored Procedure error Try following:     - CREATE PROCEDURE SP_rmp_STP_ECL (IN vPERIODID INT) - Use :vPERIODID .... instead of vPERIODID - Confirm your INSERTS run fine outside of SP
67212 Apr 2014 @ 11:06 PDTGeneralReplyIs my table going to be Skewed?Yes, it will be exactly as krishaneesh suggested.   If this is not part of your automated batch, you can create Table2 WITH NO DATA option and then get the DDL and change it ro suit our need...
67111 Apr 2014 @ 04:46 PDTDatabaseReplyForce Result Set to Return Column Names and Not Column TitlesIs your linked server a Teradata system?
67011 Apr 2014 @ 04:43 PDTDatabaseReplyReference material to get started with teradataYou can also visit Teradata Certification website below and can find the list of books  for each area:   http://www.teradata.com/teradata-certified-professional-program/
66911 Apr 2014 @ 04:41 PDTDatabaseReplyConversion of Oracle's CONNECT BY...STARTING WITH to TeradataYou can learn about recursive views from below link:   http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1144_111A/Create_Procedure-Syntax.023.56.html &n...
66809 Apr 2014 @ 11:35 PDTData ModelingReplySurrogate vs business keysIn a perfect world or ideal scenario .... which, unfortunately we dont live in .... natural keys or business keys would be preferred as there wont be an overhead of generating and maintaining SKs. ...
66709 Apr 2014 @ 11:26 PDTData ModelingReplyUnderstanding on Data modeling conceptsYou can check the details at following link: http://www.teradata.com/logical-data-models/communications/   And you can surely use the 'Contact Us' feature. Am not very sure if i...
66609 Apr 2014 @ 11:15 PDTDatabaseReplyInsert not workingWhats the error it throws?
66509 Apr 2014 @ 11:14 PDTDatabaseReplyCDCVery nice piece of code shared by sgarlapa.
66409 Apr 2014 @ 11:09 PDTDatabaseReplyTeradata New BieHave you checked Teradata documentation that should be with your DBA? That can serve as a good starting point.
66309 Apr 2014 @ 11:08 PDTDatabaseReplyFASTLOAD errorNo there is no limitation on records in the text file.   Can you share your FL script and sample data [2-3 rows]?
66209 Apr 2014 @ 11:06 PDTDatabaseReplyTeradata version detailsI am not sure if there is any architectural change in TD 12-14.   Adding different functionalities has been there but not architectural changes.   Dieter can confirm this.
66109 Apr 2014 @ 02:42 PDTDatabaseReplyerror when CALLing Teradata SP from C#Which session mode was used when SP was compiled? Use same session-modes for compiling and calling the SP.
66009 Apr 2014 @ 02:41 PDTData ModelingReplyNovice seeking help for teradata EDW modellingAs far as data-modelling is concerned, 3NF is suggested and you can use star or snow-flake style.   The only part that you would find new is the way how indexes work. So you should gather kn...
65909 Apr 2014 @ 02:38 PDTDatabaseReplyhow to know the % table size growth/reduce in teradataIf you only want to achieve this knowledge of stale-stats from this .... why dont you just create COLLECT STATS script and schedule it with your batch?   If in some tables the data volume is...
65809 Apr 2014 @ 01:22 PDTDatabaseReplyHow to create auto generated ID in volatile table?You can use the last 3 posts at the following link:   http://forums.teradata.com/forum/database/generate-surrogatekey-with-a-huge-table
65709 Apr 2014 @ 01:20 PDTDatabaseReplyFinding User informationIf you can share more about what you are trying to achieve, we may be able to help you in a better way.
65609 Apr 2014 @ 01:18 PDTDatabaseReplyFinding User informationhttp://forums.teradata.com/forum/tools/how-to-convert-ordinal-julian-date-to-calendar-date
65509 Apr 2014 @ 01:16 PDTDatabaseReplySET table to Multiset TableSimple answer would be .... No.  :)
65409 Apr 2014 @ 01:15 PDTAnalyticsReplyDependancies on DBC for Data ProcessingThere are many implementations which use metadata for the processing or logging purpose. It should be used and there is no issues with it.   The only concern that comes in my mind would be c...
65309 Apr 2014 @ 12:29 PDTDatabaseReplyMaximum Data Block SizeThe following link gives the overview on DATABLOCKSIZE:   http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details.012.032.html &...
65208 Apr 2014 @ 11:42 PDTGeneralReplyHow we can replicate Tables structures between 2 teradata servers ?No further easy way to do so from what you are doing.   You can enhance the current process [if not already done] by automating the process of exporting DDLs and applying them at target serv...
65108 Apr 2014 @ 11:39 PDTDatabaseReplyTeradta Error 6908Are the statements generated at run-time or are hard-coded? Is ';' used at the end of each statement? Are the requests being sent to DB concatenated?
65008 Apr 2014 @ 11:36 PDTCloud ComputingReplyTrustworthy cloud computing service?This forum is specifically for Teradata and we can only comment on any other service based on our personal experience.   How much data-size are you talking about here?
64908 Apr 2014 @ 11:32 PDTDatabaseReplyNumber Datatype issue with TeradataShould have gone to Informatica forum ..... as its more of an Informatica issue.   Also, if the data-type is INTEGER at source and target, why Informatica is converting it to DOUBLE? It shou...

Pages