#DateForumTypeThreadPost
275313 May 2014 @ 12:43 PDTDatabaseReply incremental planning and execution (IPE)Hu Ulrich, IPE should kick in if it reduces the overall runtime, so this query probably accessed too small tables. I usually get the same when I try it on a VM :-)
275213 May 2014 @ 12:15 PDTDatabaseReplyQuerybanding and Changing WorkloadOf course you can assign a workload based on QueryBand or whatever you want, you just have to check where/if it fits into your current WL definitions/state matrix. This has to be done using the Wo...
275113 May 2014 @ 12:02 PDTGeneralReply default character set in teradataHi Puru, they probably confuse server and client character sets :-) LATIN or UNICODE are server character sets, while ASCII or UTF-8 or UTF-16 are client character sets. There's a defau...
275012 May 2014 @ 11:50 PDTDatabaseReplyattunity driver and TPT Export error encountered during initiate phaseBoth substr(orig_string, 3, 4) and substring(orig_string from 3 for 4) are valid TD SQL, the latter is the official Standard SQL version, just SQL Server's substring(orig_string, 3, 4) is inval...
274912 May 2014 @ 10:50 PDTGeneralReplyignore a row based on the result"no match found" -> INNER join instead of LEFT "multiple rows returned" -> QUALIFY COUNT(*) OVER (PARTITION BY a.badge_num) = 1  
274812 May 2014 @ 12:11 PDTDatabaseReplyattunity driver and TPT Export error encountered during initiate phaseThere's no comparison operator != in Teradata/Standard SQL, but depending on some ODBC settings the driver automatically replaced it with valid syntax: <> Connecting through CLI (like TP...
274712 May 2014 @ 10:52 PDTGeneralReplyGetting error 2666. Invalid dates supplied for CALDATES.cdateSysCalendar.Calendar is a view, the column CALDATE comes from the base table. Your problem is the (IHMO stupid) ANSI Interval calculation, e.g. DATE '2012-02-29' - INTERVAL '1' YEA...
274612 May 2014 @ 10:22 PDTGeneralReplyAny thoughts on my specific requirement?You'll find some examples in the "Teradata Parallel Transporter User Guide" plus matching scripts in the C:\Program Files\Teradata\Client\xx.xx\Teradata Parallel Transporter\sample di...
274512 May 2014 @ 09:40 PDTGeneralReplyAny thoughts on my specific requirement?I can think of two ways to get Excel data into TD using: TD's OLE DB Access Module (to extract from Excel via a OLE DB provider) within a FastLoad, this is covered in the Teradata ...
274412 May 2014 @ 08:31 PDTDatabaseReplyHow to write SELECT statement in NULLIF or COALESCE functionHi SK,  TD12 does not support Scalar Subqueries like yours within a CASE/COALESCE, you need TD13. But you can still rewrite using a Left Join.
274312 May 2014 @ 08:29 PDTAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedHi vigneshnathan23,. this should work: QUALIFY MAX(gender) OVER (PARTITION BY section) = 'F' AND MAX(gender) OVER (PARTITION BY grade) = 'F' 2nd time: Please create...
274212 May 2014 @ 08:22 PDTDatabaseReplySkew, amp and column selectionAdding another column to a PI should not increase skew (unless you test it on avery small table). How many AMPs are on your system and how many rows do you use for testing? Usually you get almost...
274112 May 2014 @ 08:18 PDTDatabaseReplyReplacement for NAMED column - how do I get column names and TITLEsHi Rhonda, that's strange. The last version should be the correct one, (TITLE...) AS ..., and should return the title. Seems to be a parser problem, you might contact TD support to get ...
274012 May 2014 @ 08:07 PDTGeneralReplyAny thoughts on my specific requirement?Hi Nath, what's your SSIS release? You should be able to modify your existing SSIS workflow to load to TD instead of SS, there's a MS Connector for TD at http://www.microsoft.com/en-...
273912 May 2014 @ 08:01 PDTGeneralReplyvarios doubts on table creation in teradataCREATE TABLE AS existing table copies all index definitions and table/column options (like FORMAT, NOT NULL or SET/MULTISET), while CREATE TABLE AS SELECT drops all those resetting everyt...
273812 May 2014 @ 07:53 PDTDatabaseReplyHow to write SELECT statement in NULLIF or COALESCE functionHi SK, there probably was a cut&paste problem. COALESCE( (select abc from Tablename where ddf = 'CUSTOMER_TYPES' ) , ats_contract_code, 'N/A') If this is still not working ...
273710 May 2014 @ 08:54 PDTTeradata StudioReplyHow to lad the keycolumn level sapaces data I still don't get it: Do you want to load those leading spaces or not? If yes, then you should be fine as TD does not remove leading blanks by default. When they are removed it must be done e...
273609 May 2014 @ 02:18 PDTDatabaseReplyHow to write SELECT statement in NULLIF or COALESCE functionHi SK, you were quite close: COALESCE(COALESCE( (select abc from Tablename where ddf = 'CUSTOMER_TYPES' ) , ats_contract_code, 'N/A' But I would always try to rewrite those Sca...
273509 May 2014 @ 01:31 PDTTeradata ApplicationsReplyprotect table from being deletedIs this done using Viewpoint's DataLab portlet? I never worked with that, so I don't know the available options. If it's done manually, it's just granting CREATE TABLE instead of T...
273409 May 2014 @ 07:21 PDTTeradata ApplicationsReplyprotect table from being deletedPeople usually drop tables because the lab db is running out of perm space and then it's not "accidentially", it's "let's look for big tables created by others&...
273309 May 2014 @ 07:14 PDTAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derived@Qaisar: there's no ORDER BY for individual SELECTs in a UNION :-) SELECT * FROM tab ORDER BY CASE WHEN location = 'ban' then 0 else 1 END ,location @vigneshnathan23: Ple...
273209 May 2014 @ 07:10 PDTGeneralReplydifference between HASH INDEX and SINGLE TABLE JOIN INDEXHi Purushotham, please create a new topic for new questions. You don't specify Worktables in FastLoad cause there are no Worktables in FastLoad :-)
273107 May 2014 @ 11:08 PDTDatabaseReplyTERADATAHi Abhilash, it is the right query :-) WHERE START_DT <= 'your END date' AND END_DT >= 'your START date'  
273007 May 2014 @ 09:19 PDTDatabaseReplyMvc Compression and Collect Stats on TD 14Did you check the tablesize after adding MVC? If resource usage went down 30% i would expect a way smaller table. I made a mistake, TD14.10 automatically tries to find the best sample size, b...
272907 May 2014 @ 05:24 PDTToolsReplyBTEQ DATA FILEHi Anil, you EXPORT DATA, but IMPORT INDICDATA, it should be the same for both EXPORT and INPORT. INDICDATA keeps information about NULLs, when your data actually has NULL you should use this ove...

Pages