748 | 26 Jan 2016 @ 04:56 PST | Database | Reply | BTEQ export FastLoad Import issue | Can you share the sample output file that is generated via export?
|
747 | 26 Jan 2016 @ 04:53 PST | Private Forum |
746 | 09 Sep 2015 @ 09:32 PDT | Database | Reply | how to get rows with a blank value in a column | Also .... Empty string i.e. '' .... is not as same as NULL .... NULL represents absence of any value whereas empty string is a value itself.
HTH!
|
745 | 09 Sep 2015 @ 09:23 PDT | Database | Reply | how to get rows with a blank value in a column | You can use something like below:
SELECT *
FROM TABLE
WHERE TRIM(SSN) = '' OR SSN IS NULL
|
744 | 30 Aug 2015 @ 08:28 PDT | General | Reply | SQL (combine multiple insert-sel statements into one ) | Any specific reason for not using UNION/UNION ALL?
|
743 | 30 Aug 2015 @ 08:26 PDT | General | Reply | Teradata Express tbuild Error | I would try with other VM image than 40GB one.
HTH!
|
742 | 30 Aug 2015 @ 08:24 PDT | General | Reply | tuning query | Try removing the derived tables. Query is poorly written in Informatica's SQL Override. Perhaps, try implementing the logic in Informatica itself.
HTH!
|
741 | 30 Aug 2015 @ 08:23 PDT | General | Reply | Spoil Table information in Data Dictionary | It doesn't have much impact on performance. It is the step to cleanup structure from DD.
|
740 | 30 Aug 2015 @ 08:21 PDT | General | Reply | to know the stats defined for the table | You can get this info from DBC.COLUMNS table. There are two fields of your interest: CreateTimestamp & LastAlterTimestamp.
HTH!
|
739 | 30 Aug 2015 @ 07:59 PDT | Database | Reply | i am new to teradata developement | I 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... |
738 | 30 Aug 2015 @ 07:55 PDT | Database | Reply | Need 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?
|
737 | 30 Aug 2015 @ 07:52 PDT | Database | Reply | Oracle Table to Teradata DDL | There 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... |
736 | 30 Aug 2015 @ 07:47 PDT | Database | Reply | how to join multiple tables in Teradata | SQL 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... |
735 | 30 Aug 2015 @ 07:43 PDT | Database | Reply | Random 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... |
734 | 30 Aug 2015 @ 05:04 PDT | Database | Reply | Submitting Procedures using BTEQ | I would assume it can be due to the different nature of BTEQ and SPL.
HTH!
|
733 | 30 Aug 2015 @ 05:02 PDT | Database | Reply | Teradata query tunning | What are the definitions & size of A and B?
|
732 | 30 Aug 2015 @ 05:01 PDT | Database | Reply | cast varchar value YYYY-MMM-DD HH:MI:SS to date | Yes, Rohan is correct. Though TIMESTAMP(0) will work fine as well.
HTH!
|
731 | 30 Aug 2015 @ 04:56 PDT | Database | Topic | Views - Internal execution steps | Hi,
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... |
730 | 29 Apr 2014 @ 01:32 PDT | Data Modeling | Reply | Surrogate vs business keys | True, 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... |
729 | 29 Apr 2014 @ 01:15 PDT | Database | Reply | Issues with Teradata Parallel Transporter(TPT) with Informatica | It can be due to UTF encoding issue .... can you check if source-TPT-target is configured to use same encoding?
|
728 | 28 Apr 2014 @ 10:37 PDT | General | Reply | Difference between Teradata utilities | If 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 ... |
727 | 28 Apr 2014 @ 10:34 PDT | Tools | Reply | Sql assistant complaining about dot net framework | Which 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?
|
726 | 26 Apr 2014 @ 10:22 PDT | Database | Reply | Casting 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?
|
725 | 26 Apr 2014 @ 10:19 PDT | Database | Reply | Remove the first 4 characters in a string | Or for a generic solution [in case '-' can come in data at any other length] .... you can use:
SELECT SUBSTR(state, INDEX(state, '-') + 1)
|
724 | 26 Apr 2014 @ 10:14 PDT | General | Reply | Release 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.
|