74826 Jan 2016 @ 04:56 PSTDatabaseReplyBTEQ export FastLoad Import issueCan you share the sample output file that is generated via export?
74726 Jan 2016 @ 04:53 PSTPrivate Forum
74609 Sep 2015 @ 09:32 PDTDatabaseReplyhow to get rows with a blank value in a columnAlso .... Empty string i.e. '' .... is not as same as NULL .... NULL represents absence of any value whereas empty string is a value itself.   HTH!
74509 Sep 2015 @ 09:23 PDTDatabaseReplyhow to get rows with a blank value in a columnYou can use something like below: SELECT * FROM TABLE WHERE TRIM(SSN) = '' OR SSN IS NULL
74430 Aug 2015 @ 08:28 PDTGeneralReplySQL (combine multiple insert-sel statements into one )Any specific reason for not using UNION/UNION ALL?
74330 Aug 2015 @ 08:26 PDTGeneralReplyTeradata Express tbuild Error I would try with other VM image than 40GB one.   HTH!
74230 Aug 2015 @ 08:24 PDTGeneralReplytuning queryTry removing the derived tables. Query is poorly written in Informatica's SQL Override. Perhaps, try implementing the logic in Informatica itself.   HTH!
74130 Aug 2015 @ 08:23 PDTGeneralReplySpoil Table information in Data DictionaryIt doesn't have much impact on performance. It is the step to cleanup structure from DD.
74030 Aug 2015 @ 08:21 PDTGeneralReplyto know the stats defined for the tableYou can get this info from DBC.COLUMNS table. There are two fields of your interest: CreateTimestamp & LastAlterTimestamp.   HTH!  
73930 Aug 2015 @ 07:59 PDTDatabaseReplyi am new to teradata developementI would understand the high-level design and the kind of tasks (SQL scripts, ETL tool, Scheduling, Testing, Release management, etc.) i would be required to work on. Based on that input I would der...
73830 Aug 2015 @ 07:55 PDTDatabaseReplyNeed help to write an SQL to validate mutiple date ranges combined from more than one SCD type2 tables.Would it be feasible to write an SP for you/your team?
73730 Aug 2015 @ 07:52 PDTDatabaseReplyOracle Table to Teradata DDLThere is a small utility ( i wouldn't call it a tool) to do this task, but even that doesn't generate the output which can be used as-is .... meaning it involves manual effort to get the be...
73630 Aug 2015 @ 07:47 PDTDatabaseReplyhow to join multiple tables in TeradataSQL will run faster if you filter out the rows early in the process. Yes, optimizer will find and use the best way to run the given SQL.   It's more of a design choice how you want to us...
73530 Aug 2015 @ 07:43 PDTDatabaseReplyRandom sampling question When you say you know 'how to randomly grab' what exactly do you mean?   Basically, what you need is RANK function with PARTITION on Agent, and put a QUALIFY on that RANK to filter o...
73430 Aug 2015 @ 05:04 PDTDatabaseReplySubmitting Procedures using BTEQI would assume it can be due to the different nature of BTEQ and SPL.   HTH!
73330 Aug 2015 @ 05:02 PDTDatabaseReplyTeradata query tunningWhat are the definitions & size of A and B?
73230 Aug 2015 @ 05:01 PDTDatabaseReplycast varchar value YYYY-MMM-DD HH:MI:SS to dateYes, Rohan is correct. Though TIMESTAMP(0) will work fine as well.   HTH!
73130 Aug 2015 @ 04:56 PDTDatabaseTopicViews - Internal execution stepsHi,   I have a quick question regarding processing of views.   Consider a view on top of a single physical table, which has a complex (pivoting and calculations) logic. Physical table...
73029 Apr 2014 @ 01:32 PDTData ModelingReplySurrogate vs business keysTrue, thats because creating & maintaining SKs is lot cheaper as compared to the efforts of introducing SK [if ever] once the new systems becomes the source of same information which is being b...
72929 Apr 2014 @ 01:15 PDTDatabaseReplyIssues with Teradata Parallel Transporter(TPT) with InformaticaIt can be due to UTF encoding issue .... can you check if source-TPT-target is configured to use same encoding?
72828 Apr 2014 @ 10:37 PDTGeneralReplyDifference between Teradata utilitiesIf I understand your question correctly .... you are asking if you can load a Teradata table using TDUs to a Teradata table .... well .... in-DB processing gives you better performance as compared ...
72728 Apr 2014 @ 10:34 PDTToolsReplySql assistant complaining about dot net frameworkWhich version of .NET Framework you have? And which version of SQLA you are trying to install? And what is the exact error you are getting?
72626 Apr 2014 @ 10:22 PDTDatabaseReplyCasting Varchar date value to timestamp with differnt formats Is the format of these two DATE fields fixed? Whats the format of TIMESTAMP(0) column? Are they all different columns? Can you share more clear example with input & output?
72526 Apr 2014 @ 10:19 PDTDatabaseReplyRemove the first 4 characters in a stringOr for a generic solution [in case '-' can come in data at any other length] .... you can use:   SELECT SUBSTR(state, INDEX(state, '-') + 1)
72426 Apr 2014 @ 10:14 PDTGeneralReplyRelease MLOAD lock Using Informatica RELEASE MLOAD is a Teradata SQL statement that is recognized by BTEQ and Teradata MultiLoad, hence it might not be supported in SP.