#DateForumTypeThreadPost
79628 Jul 2014 @ 09:37 PDTAnalyticsReplyGenerate a automated Nested CASE STATEMENT using entries from a tableI think you are looking for an opportunity to automate the process. I see people get faster response by showing sample , this is what I have and this is the output required. The sentence hiera...
79528 Jul 2014 @ 08:50 PDTDatabaseReplyPartition integer date key by monthI  was about to comment on posting_dt_key integer declaration in partition. I think you  may have something in mind about it when you made it integer, since you know the end reqt and data...
79428 Jul 2014 @ 11:51 PDTTeradata ApplicationsReplyEasyloader data transfer issueI am not pretty sure. My guess is the length behaviour of tpt. Did you try increasing the length in schema, maybe 3 times. I m not sure. I remember vaguely about this discussion. It maybe wrong. ...
79328 Jul 2014 @ 11:20 PDTDatabaseReplyhelp with SQLA quick look at the data it can be thus. select distinct max(case when id is null then 0 else id end) over (partition by id,dt order by id,dt), max(case when dt is null then 0 else dt end) over ...
79228 Jul 2014 @ 10:47 PDTDatabaseReplyIdentify Set - Multiset Tables in TD 14In td mode, it will be set table. If you want to change to multiset by default, then it has to be changed to ANSI mode. You may need to MODIFY in dbs control settings in GENERAL , if my memory does...
79126 Jul 2014 @ 06:52 PDTTeradata StudioReplyInstalling Teradata in Windows 8For hiccups and solutions for installation, folks refer to links under  http://forums.teradata.com/forum/cloud-computing You can read the link here also  http://developer.teradata.co...
79025 Jul 2014 @ 11:19 PDTDatabaseReplyTeradata Reports are running very slowThere could be many reasons. There can be many questions What are the configurations you have...nodes, amps..... How many users? Size of tables (it may increase over time). Skewed tables may the...
78925 Jul 2014 @ 10:45 PDTDatabaseReplyDENSE_RANKIn 14.10 it is very much there, you can see select empid,deptno,sal,dense_rank() over (partition by deptno order by sal) from employee;
78824 Jul 2014 @ 09:45 PDTDatabaseReplyIdentify Multicolumn Foreign key on TD 14Is this what you are looking for? http://forums.teradata.com/forum/database/how-display-list-of-foreign-key-constraints-including-with-no-check-option-setting  
78724 Jul 2014 @ 09:32 PDTDatabaseReplyOracle to teradata migration There are lots of posts on this , since many folks are migrating from oracle to teradata. Few links for referrals are https://forums.teradata.com/forum/database/teradata-data-types-to-oracle http...
78624 Jul 2014 @ 09:14 PDTDatabaseReplyGet the previous row's column ValueI thibk this is what you are looking for. rows between 1 following and 1 following 
78523 Jul 2014 @ 08:53 PDTDatabaseReplyregexp_substr in TD14.10Try with a combination of  strtok_split_to_table.  SELECT * FROM TABLE (strtok_split_to_table(1,'a,b,c,"abc,def,dfg",m,n,"hi,how,are you",g,k', ',/') ...
78422 Jul 2014 @ 07:41 PDTDatabaseReplyQuery DBC Tables/Columns To Find Empty ColumnsI dont think any database will have this option(dictionary) to check or they will make it if it is meant for huge database. Their engine will be really too busy.
78322 Jul 2014 @ 01:28 PDTTrainingReplyTeradata trainingYou could have searched or posted in http://forums.teradata.com/forum/training . Good or fair or bad ..... is difficult to comment. The suggestion I can give is know what you want or expect&n...
78220 Jul 2014 @ 09:18 PDTDatabaseReplyConcatenating texts while summarizing data Whew!!!  you have to get one else you can do something thus.   select id,max(case when rn=1 then ofr else '' end)||'|'||max(case when rn=2 then ofr else '' end),...
78119 Jul 2014 @ 09:47 PDTDatabaseReplyConcatenating texts while summarizing data Which td version you are in? select mem, tdstats.udfconcat(ofr),sum(sales) from your_table group by 1;    
78019 Jul 2014 @ 06:02 PDTGeneralReplyReplace a String in column It does not require license. You have in vmware too. If I am not wrong,in  TD 14 it's introduced. I work on 14.10 and it is very much there.
77918 Jul 2014 @ 09:31 PDTGeneralReplyReplace a String in column Which TD Version you are using? Do you have oreplace2? You can check with your DBA if you do not have. You can use regexp_replace thus: select regexp_replace('replace view as (select',...
77818 Jul 2014 @ 08:54 PDTDatabaseReplyCorrect usage of TeradataTechonology(Teradata) is perfect.  I think it is all about space management and allocation, infra and maybe you can consult   DBAs.
77718 Jul 2014 @ 05:37 PDTDatabaseReplyUSLARE in TeradataNever heard of that word. Perchance ,it is USL( UNITY SOURCE LINK), allowing to read from other DBs like Oracle?
77616 Jul 2014 @ 09:34 PDTDatabaseReplyRelation between Database and Users I think you will come to know the difference when you implement the scenarios like temporary, volatile tables and querying and you can check your space allocated.   You can refer to...
77515 Jul 2014 @ 08:12 PDTDatabaseReplyCreating database allowing for attachmentsI hope you are talking about large objects BLOB, CLOB . There are lots of documents available. You can refer to http://developer.teradata.com/applications/articles/large-objects-part-1-loading...
77415 Jul 2014 @ 05:30 PDTDatabaseReplyNew to Teradata Help with data typeIf you check the phone formats of each country, you will see some formats and some countries have quite a number :) . I don't think any DBMS will resort to using phone as a datatype.
77315 Jul 2014 @ 05:22 PDTDatabaseReplySource/Version control for DDL?I have less experience on SVN. I worked on one proposal only where it has Teradata. Since SVN is quite recent, it should integrate well with TD. This is my understanding.
77214 Jul 2014 @ 10:56 PDTDatabaseReplySource/Version control for DDL?I think you are looking for checkin ...checkout versioning tool and repository, code deployment etc. As far as I know , there is none. SVN, CVS etc can be used for repository..deployment ...... I ...

Pages