#DateForumTypeThreadPost
34618 Dec 2013 @ 06:50 PSTJobsReplyTeradata training ..Hi, Regarding online, some posts are given in http://forums.teradata.com/forum/training . Get the feedback from those who attended. Cheers, Raja
34518 Dec 2013 @ 12:06 PSTToolsReplyquery schedulerHi, You can download the document from this link if it helps you. Ideally it should allow both. http://www.info.teradata.com/templates/eSrchResults.cfm?txtttlkywrd=tqs&txtrelno=&srtord=De...
34417 Dec 2013 @ 11:11 PSTDatabaseReplyDifference between NUSI and Hash ordered NUSI? Hi Nishant,   I have never encountered that situation in real time. However,my findings are highlighted below:   USIs are always stored in hash order on an AMP, while N...
34317 Dec 2013 @ 11:07 PSTData ModelingReplyFinancial.... LDM Hi Nancy, Thanks for the information. It is difficult for me to remember, since I worked in uLDM, CLDM and FSLDM in previous projects. I hope in CLDM we still have 8 subject areas. R...
34217 Dec 2013 @ 09:10 PSTData ModelingReplyErwin report template Hi Roland and Lee, Thanks! I see very much sense there. Perceptibly, it reduces coding if we know erwin functionalities :). Regards, Raja
34117 Dec 2013 @ 08:37 PSTDatabaseReplyJoining tables on fields with varying lengthsHi, You can use a combination of TRIM and cast: Try this:    TRIM (BOTH '0' FROM CAST(A.ACCT_NB AS CHAR(50)))  or varchar.   Cheers, Raja
34017 Dec 2013 @ 04:41 PSTDatabaseReplyError in update statementMaybe you can dont you try with merge into statement?   similar to   MERGE INTO Department       USING USING (SELECT ....... FROM contact WHERE contact_...
33917 Dec 2013 @ 03:17 PSTGeneralReplyOracle to Teradata query conversionHi, A quick look at the code, I can see that when you remove distinct, it works. Now since you may land up without distinct( i.e duplicates), then you can think of putting this in a derived query ...
33817 Dec 2013 @ 02:24 PSTData ModelingTopicErwin report template Hi, I am not sure which one to run in erwin: CSV Entity names or CSV Tablename? They look to be the same? Under what circumstances, we may have different reports? Same thing happens wit...
33717 Dec 2013 @ 12:06 PSTTrainingReplyTeradata advance training/guidance for certificationI feel that Teradata Corporation can think of opening centres in those IT cities like other competitors, since Teradata is widely used across industries. In Bangalore and some cities, I know in In...
33616 Dec 2013 @ 11:40 PSTTeradata ApplicationsReplyLimit on a tableAh ha! Thanks Dieter. But yes a statement level trigger maybe a good option, though I have not implemented in Teradata. Thanks, Raja
33516 Dec 2013 @ 11:31 PSTAnalyticsReplyFast Load Vs MultiloadI feel that at the end of the day, it depends on what suit the end requirements well. But just a comparison of fload and mload for empty tables and no indices, fload is a bit faster(though both are...
33416 Dec 2013 @ 11:09 PSTAnalyticsReplyFast Load Vs MultiloadHi Sankalp, You can address me as Raja (not Rajat...it has different meaning :)). Cheers, Raja
33316 Dec 2013 @ 09:32 PSTDatabaseReplyMultiple Grand Totals Hi, It seems you miss out the BY + fieldname. I am not sure if it allows for multiple with sum too. I test for onewith sum(xxx) by field1.... it works fine. However, I test this way ...
33216 Dec 2013 @ 08:57 PSTGeneralReplyPPI - Secondary IndexesHi Cheeli, The above statements are the choices you have when in your design consideration. I have not tested this but it is proven as disadvantages of PPI.  Yes , when partitioning column s...
33116 Dec 2013 @ 08:25 PSTTeradata ApplicationsReplyFASTLoad to load UK companies house dataHi Andy, Thanks for sharing. May I know if we can use in TD 13.10? Cheers, Raja
33016 Dec 2013 @ 08:21 PSTTeradata ApplicationsReplyLimit on a tableHi Sankalp, I think you may need to have a look at temporal features(Valid time, transaction time and bitemporal tables) of Teradata and then use a script to purge data to table2.  The have ...
32916 Dec 2013 @ 09:50 PSTAnalyticsReplyFast Load Vs MultiloadFastload has two phases: acquisition phase and application phase. mload has 5 phases(Note: however there is no acquisition phase for mload delete). mload phases: Preliminary,DML Transaction,A...
32816 Dec 2013 @ 05:31 PSTDatabaseReplyExtractin a QUERY TEXT from a Column and using this output we need to insert the data into another table. I hope you understand this logic 1:  select 'insert into '||trim(databasename)||''||trim(tablename) from dbc.tables where tablename='raja_test' and databasename=...
32716 Dec 2013 @ 04:15 PSTDatabaseReplyExtractin a QUERY TEXT from a Column and using this output we need to insert the data into another table. Hi, What I did is something liks this to get the insert into : select 'insert into '||trim(databasename)||''||trim(tablename) from dbc.tables where tablename='raja_te...
32616 Dec 2013 @ 03:09 PSTDatabaseTopicsystemfe.allrestartHi, I am executing systemfe.allrestarts with two parameters, but I dont have premission. So I am using as a next way DBC.Software_Event_Log. However, when I use select distinct  function &nbs...
32516 Dec 2013 @ 12:29 PSTDatabaseReplyWhy teradata does not give access to statistics views in dbc by default?Similar to all other DBs like oracle, ms sql, sybase etc, you have the rights. You can have a look at dbc.StatsTbl.  If you don't see any DB object, you contact the DBA. In oracle, you ca...
32415 Dec 2013 @ 10:46 PSTTrainingReplyteradata training Hi Ankit, You have not explained about the mode of training: online or  virtual etc. , the location . So if you  provide more details, then others can help you more. If you browse, more...
32315 Dec 2013 @ 10:39 PSTGeneralReplyTeradata Certification re-take policyHi Gaurav, As to the fees, you can also see in this link. FAQs are provided here. http://in.teradata.com/tcpp-faq.aspx?id=6020 .Also you can see the hyperlink:   Do I have to pay for ...
32215 Dec 2013 @ 08:42 PSTGeneralReplyHow to configure Dial up Server on SWS Server in Teradata6650CHi Setsuo, I dont know whether it will help you or not Way back in 2004, I just recall when I worked in one project that my lead was working with the internet provider or vendor so that servers w...

Pages