673 | 12 Apr 2014 @ 11:12 PDT | General | Reply | Stored 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
|
672 | 12 Apr 2014 @ 11:06 PDT | General | Reply | Is 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... |
671 | 11 Apr 2014 @ 04:46 PDT | Database | Reply | Force Result Set to Return Column Names and Not Column Titles | Is your linked server a Teradata system?
|
670 | 11 Apr 2014 @ 04:43 PDT | Database | Reply | Reference material to get started with teradata | You 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/
|
669 | 11 Apr 2014 @ 04:41 PDT | Database | Reply | Conversion of Oracle's CONNECT BY...STARTING WITH to Teradata | You 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... |
668 | 09 Apr 2014 @ 11:35 PDT | Data Modeling | Reply | Surrogate vs business keys | In 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. ... |
667 | 09 Apr 2014 @ 11:26 PDT | Data Modeling | Reply | Understanding on Data modeling concepts | You 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... |
666 | 09 Apr 2014 @ 11:15 PDT | Database | Reply | Insert not working | Whats the error it throws?
|
665 | 09 Apr 2014 @ 11:14 PDT | Database | Reply | CDC | Very nice piece of code shared by sgarlapa.
|
664 | 09 Apr 2014 @ 11:09 PDT | Database | Reply | Teradata New Bie | Have you checked Teradata documentation that should be with your DBA? That can serve as a good starting point.
|
663 | 09 Apr 2014 @ 11:08 PDT | Database | Reply | FASTLOAD error | No there is no limitation on records in the text file.
Can you share your FL script and sample data [2-3 rows]?
|
662 | 09 Apr 2014 @ 11:06 PDT | Database | Reply | Teradata version details | I 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.
|
661 | 09 Apr 2014 @ 02:42 PDT | Database | Reply | error 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.
|
660 | 09 Apr 2014 @ 02:41 PDT | Data Modeling | Reply | Novice seeking help for teradata EDW modelling | As 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... |
659 | 09 Apr 2014 @ 02:38 PDT | Database | Reply | how to know the % table size growth/reduce in teradata | If 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... |
658 | 09 Apr 2014 @ 01:22 PDT | Database | Reply | How 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
|
657 | 09 Apr 2014 @ 01:20 PDT | Database | Reply | Finding User information | If you can share more about what you are trying to achieve, we may be able to help you in a better way.
|
656 | 09 Apr 2014 @ 01:18 PDT | Database | Reply | Finding User information | http://forums.teradata.com/forum/tools/how-to-convert-ordinal-julian-date-to-calendar-date
|
655 | 09 Apr 2014 @ 01:16 PDT | Database | Reply | SET table to Multiset Table | Simple answer would be .... No. :)
|
654 | 09 Apr 2014 @ 01:15 PDT | Analytics | Reply | Dependancies on DBC for Data Processing | There 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... |
653 | 09 Apr 2014 @ 12:29 PDT | Database | Reply | Maximum Data Block Size | The 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
&... |
652 | 08 Apr 2014 @ 11:42 PDT | General | Reply | How 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... |
651 | 08 Apr 2014 @ 11:39 PDT | Database | Reply | Teradta Error 6908 | Are 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?
|
650 | 08 Apr 2014 @ 11:36 PDT | Cloud Computing | Reply | Trustworthy 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?
|
649 | 08 Apr 2014 @ 11:32 PDT | Database | Reply | Number Datatype issue with Teradata | Should 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... |