#DateForumTypeThreadPost
42101 Jan 2014 @ 06:23 PSTGeneralReplyDatatypes and Usefulness Hi Mithun,   For integer, you have these options: Datatype Byte Range BYTEINT     1     -128 thru 127 SMALLINT    2     32768 t...
42031 Dec 2013 @ 09:44 PSTCloud ComputingReplyVMWARE and TD 14.10Hi, I downloaded both vmware player and TD  Actions Done: 1 VMware-guest64check-5.5.0-18463---- To check the OS compatibility---IT PASSES OK 2 TDExpress14.10_Sles11_40GB  - Down...
41931 Dec 2013 @ 04:22 PSTDatabaseReplyUnable to Create a Columnar Table after upgrading to 14Hi, I  think it is because of licenses, since it is not enabled. There are few features like Temporal, Virtual Storage etc, that need licenses. I am not pretty sure. Maybe you can double chec...
41831 Dec 2013 @ 02:30 PSTDatabaseReplyteradata trainingHi, You could have posted under Training heading http://forums.teradata.com/forum/training . You have not explained about the mode of training: online or  virtual etc. , the loc...
41731 Dec 2013 @ 02:24 PSTCloud ComputingTopicVMWARE and TD 14.10Hi, I collect information  from here , to install  TD 14.10 in my new laptop. I got these two links: https://my.vmware.com/web/vmware/free#desktop_end_user_computing/vmware_player/6_...
41631 Dec 2013 @ 02:01 PSTGeneralReplyIssue with MLOAD Error tablesI am not able to understand clearly. However, I just smell a rat that mload  has this option IGNORE DUPLICATE ...ROWS.  Can you check the control file? This is my initail thought. Cheer...
41530 Dec 2013 @ 11:27 PSTGeneralReplyRelease MLOAD lock Using Informatica I think in informatica calling unix script,should be there, like  a sort of your restartability. One way maybe you can code in your pre-etl job, to check this calling, a unix script. In &nb...
41430 Dec 2013 @ 04:26 PSTDatabaseReplyGenerating Sequence Number when GROUP BY in the QueryOops, it is me who is with the older generation code. I used the deprecated one. I dont know from which version, this one supports. Thanks Dieter.    
41330 Dec 2013 @ 03:20 PSTDatabaseReplyDatamart Data mart is a special purpose subset of enterprise data for a particular function. It may contain detail or summary data or both. Data mart types: Independent- created directly from...
41230 Dec 2013 @ 12:19 PSTDatabaseReplyProblem with CASE WHEN statement Hi,   CASE WHEN TYPE_cD IN ('03') AND STS_CD='N' THEN 0 WHEN TYPE_CD IN ('01','02','03') THEN 1 ELSE 0 END as CNT   ...
41129 Dec 2013 @ 11:41 PSTExtensibilityReplyTeradata Integration with Salesforce Hi Mrao, Can you please share with me , about the source system( like single, multiple), cloud service etc. If it is just semantic layer, then you dont need to worry much, since your sou...
41029 Dec 2013 @ 09:34 PSTDatabaseReplyGenerating Sequence Number when GROUP BY in the QueryHi Pavan, You can't use OLAP and aggregates together. The workaround is to use derived table or temporary table. Try this:take your group by query  inside. Rank the result from obtai...
40929 Dec 2013 @ 07:53 PSTDatabaseReplyRun time explain plan for a queryHi, In oracle it is different and here it is different. You can have a look at DBC.DBQLExplainTbl . Also have a look at DBQLXMLTbl. I hope this is what you are looking for. Cheers, Raja
40829 Dec 2013 @ 07:11 PSTExtensibilityReplySHA-2 UDFs for TeradataVery good. Keep sharing your ideas. Cheers, Raja
40729 Dec 2013 @ 02:20 PSTDatabaseReplyNested joins in TeradataYou posted in another one the same. I replied there. It seems the site, registers twice. It happens sometimes for me too. Cheers, Raja  
40629 Dec 2013 @ 02:16 PSTDatabaseReplyTeradata architechtural behaviourHi Soumik, For AWT, you can have a look at this link http://developer.teradata.com/blog/carrie/2010/12/how-to-calculate-your-max-number-of-usable-amp-worker-tasks .  Carrie has giv...
40529 Dec 2013 @ 02:06 PSTDatabaseReplyNested joins in Teradata Nested join provides one of the fastest performance compared to other joins, since it does not touch all amps to join tables. It works mostly with PI/SI. The  WHERE clause uses an equijoin ...
40429 Dec 2013 @ 01:43 PSTTrainingReplyRegarding Certification Exams - Pass %Hi Srinithy,  I replied to the subject in this link  http://forums.teradata.com/forum/training/terdata-certification-in-india Cheers, Raja  
40329 Dec 2013 @ 01:31 PSTTrainingReplyTerdata Certification in IndiaYou go for 14. 2. There are a lot of enhancements from 12 to 14. Now-a-days, most of the organizations are shifting to 14~.  I suggest you go through this link http://www.register.promet...
40228 Dec 2013 @ 06:12 PSTGeneralReplyCopy DB with ArcMainHi, It reminds me , when I used to work with other products, that when we were at our wits' end, then we call the customer care to help. But  we were partners for those products. I think ...
40127 Dec 2013 @ 07:09 PSTDatabaseReplyNeed alternative to DBQL processingHi, It reminds me of the posts now. Have you enquired about  PMCP or PDCR if it suits your requirement? http://forums.teradata.com/forum/database/backuprecovery-of-dbql http://forums.terada...
40027 Dec 2013 @ 06:58 PSTAnalyticsReplyrun queries in parallel and serialTry with run files to achieve your goal, controlling with session, pack factor and repeat. Bteq  anyway allows max of 200 sessions and if I remember correctly, we can't change sessions bet...
39927 Dec 2013 @ 08:03 PSTDatabaseReplyFetching the data for thelast quarter datesWhaw this is cool. So the TRUNC second paramater, 'Q' refers to Quarter? Thanks, Raja
39827 Dec 2013 @ 04:15 PSTDatabaseReplysurrogate scripts Hi Reddy,   There are few ways of generating surrogate, but can't put the script because of restrictions  of company's policies.   One way you can generate...
39727 Dec 2013 @ 03:50 PSTDatabaseReplyarc errorHi Zhang,       Explanation: The table that is being Archived/Restored/Copied has been dropped by some other transaction. This can happen when the HUT Lock is released using...

Pages