#DateForumTypeThreadPost
57318 Feb 2014 @ 09:21 PSTDatabaseReplySSIS and Global Temp TablesIn your case, temporary tables .... be it Global TT or Volatile TT .... wont work.   Because, for GTT it retains its definition across all sessions, but data is only visible to session that ...
57218 Feb 2014 @ 10:14 PSTThird Party SoftwareReplyDatastage 8.01 running with Teradata 14.10.Running the same design shouldn't be an issue .... but in case you decide to make a change in the design .... like e.g. start using TPT from DataStage and run into some trouble, then its an iss...
57118 Feb 2014 @ 10:07 PSTTrainingReplyTeradata advance training/guidance for certificationAlot of stuff is already accessible to anyone who wants to learn Teradata.   As a start, you can get the software itself, then comes its documentation and then comes the forum where people c...
57018 Feb 2014 @ 10:03 PSTThird Party SoftwareReplyDWH/BI Project Analysis, Estimation,resource tool In my opinion .... considering the dynamic nature of projects and ever changing requirements and different amount of information available .... it is not easy to make a generic tool .... rather you...
56918 Feb 2014 @ 09:37 PSTDatabaseReplyGenerate SurrogateKey with a huge tableIndeed Dieter .... I wrote SQL on-the-fly and missed PARTITION BY in there. Thanks! :)
56818 Feb 2014 @ 09:31 PSTGeneralReplyFYP ideasBefore I could share some ideas .... my questions would be as follows:   - How good do you know about DWH? - How good are your concepts? - Are there any design/scope restrictions? - Is it...
56718 Feb 2014 @ 08:42 PSTDatabaseReplysubstr vs substring1. SUBSTRING (Text FROM 1 FOR 10) 2. SUBSTR(Text, 1, 10) 3. SUBSTRING(Text, 1, 10)   2 is Teradata extension, 3 is ODBC styled function and 1 is ANSI standard. HTH!
56618 Feb 2014 @ 08:39 PSTGeneralReplyFYP ideaswhat is 'FYP'?
56518 Feb 2014 @ 08:33 PSTDatabaseReplysubstr vs substringa. SUBSTRING(<text> FROM <start of characters> FOR <count of characters> is ANSI standard b. Both can be used, they generate same output c. Anyone can be used .... if you are co...
56418 Feb 2014 @ 08:30 PSTDatabaseReplySQL for Year and MonthNatasha, yes you can use them .... i'll reply on your post shortly.
56318 Feb 2014 @ 08:29 PSTDatabaseReplySQL for Year and MonthWelcome Raja .... regarding material you can search on the web and visit www.teradata.com for details.   In my opinion practicing is the best option .... and you need to have a documentation...
56218 Feb 2014 @ 08:14 PSTDatabaseReplySQL for Year and MonthYou just need to substr like below: CAST(Month_Name as VARCHAR(10)) || substr(CAST(Year_of_Calender as VARCHAR(4)), 3,2)   and in case you need ' .... you should use following: &nb...
56118 Feb 2014 @ 07:53 PSTDatabaseReplySQL for Year and MonthFrom what i understood .... you need to CAST both columns to VARCHAR and concatenate (using ||) to get the desired output.   CAST(Month_Name as VARCHAR(10)) || CAST(Year_of_Calender as VARCH...
56018 Feb 2014 @ 07:49 PSTToolsReplyHow to Run Fast ExportDieter's example should work, otherwise whats the error? Something to do with HOSTS file?
55917 Feb 2014 @ 11:49 PSTGeneralReplyXMLSEQUENCE and parsing name value pairs of XML dataHave you tried TeraXML?   It can be downloaded from below website:   http://downloads.teradata.com/download/extensibility/teradata-xml-services   HTH!
55817 Feb 2014 @ 11:43 PSTDatabaseReply0WSA E HostUnreach: The Teradata Server can't currently be reached over this networkTeradata Express comes with a utility known as 'Teradata Service Control' usually it has a an icon on Desktop. You can use that to start/stop Teradata services.   In case it is not t...
55717 Feb 2014 @ 11:39 PSTDatabaseReplySQLIt seems to be a simple transpose case, for which following are some related threads on forum:   http://forums.teradata.com/forum/database/transpose-rows-to-columns-0 http://forums.teradata...
55617 Feb 2014 @ 08:01 PSTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?GTT could have worked, but as the original question states .... data is large enough to cause issues for spool space.   And again, its a matter of overall load on the system .... and the num...
55517 Feb 2014 @ 07:50 PSTDatabaseReplyCompiling UDF with Object FileI am not sure if you can do that. It appears you do have .c file, then why do you require to compile using an object file?
55417 Feb 2014 @ 07:33 PSTDatabaseReplyReplacement of order by clauseIt works without any change. We are using it on TD 14.
55317 Feb 2014 @ 07:32 PSTDatabaseReplyALTER_PPIThere is no Alter PPI, you have to create a seperate table with new PPI and insert data into that.   HTH!
55217 Feb 2014 @ 07:30 PSTDatabaseReplyWant to check if two specific columns exist in more than one tableIdeally you should have this information from some kind of model.   But you can find that information using DBC.COLUMNS view.   HTH!
55116 Feb 2014 @ 07:30 PSTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?I believe sgarlapa has answered your question on the steps [inserts] required to be performed while DROP/CREATE .... whereas .... its pretty much fine to do a DROP/CREATE.   DBC ma...
55015 Feb 2014 @ 11:08 PSTTeradata ApplicationsReplyNexus Query ChameleonShouldnt this question go to Nexus Query Chameleon forums?
54915 Feb 2014 @ 10:34 PSTGeneralReplyImplications of having a part of shared disk on all AMPS - join performanceIn my opinion .... it will cause a lot of ambiguities and will be prone to error .... or cause a deadlock/bottleneck for the shared space .... hence performance will degrade .... as multiple querie...

Pages