#DateForumTypeThreadPost
3224 Dec 2012 @ 11:06 PSTDatabaseReplySkewed data handlingHey GV, Can you post the ddl for the two tables?
3122 Nov 2012 @ 05:37 PSTDatabaseReplySET & Multiset TablesHarpreet, Your option four does indeed eliminate the duplicate row and PI checks, but is also most susceptible to duplicate rows.  The duplicate tuple check should be handled by some other me...
3025 Oct 2012 @ 11:34 PDTDatabaseReplyto_char function in stored procedureIt looks like your system already has the Oracle UDF's installed, as it worked in SQL Assitant. There may be some permission issues, or you may need to fully qualify the function call, check w...
2925 Sep 2012 @ 10:21 PDTToolsReplyFast Export into a Access .mdb formatWhy not use Access to query the data?  Pull it from Access rather than "pushing" from TD.
2821 Sep 2012 @ 10:20 PDTThird Party SoftwareTopicLoading TD 13.10 Period Datatype with Informatica 9.1 workaroundMy ETL team is in search of a workaround to load a period data type with INFA 9.1.  We've tried casting period(current_date,until_changed) as a string and nearly every other workaround we ...
2731 Aug 2012 @ 02:05 PDTTeradata ApplicationsReplyIF Column1 = Column2 => Merge data of Column3 in one cell you should be able to accomplish this with some group by statements, left outer joins and a couple of <> conditions
2617 Aug 2012 @ 12:00 PDTGeneralReplyhow to Check in Explain Plan SI is used or nor If you run an explain on the query, the use of the SI will show up in the explain plan with verbiage similar to "by way of index # 4".  Your secondary and join indices will increm...
2524 Jul 2012 @ 03:08 PDTDatabaseReplyIs it possible to refresh a view every 15 minutes using a trigger? The beauty of views is that you don't have to refresh them.  New or changed data in the base table is reflected in the view without any additional action on the database's part.
2412 Dec 2011 @ 07:11 PSTGeneralReplyHelp solve this problem when loading my data It appears that the table you are trying to load has a Unique Secondary Index and the data you are attempting to insert has multiple rows that violate the uniqueness constraint of the USI. F...
2312 Nov 2011 @ 04:31 PSTThird Party SoftwareReplyMissing records within Teradata from Informatica Couple of questions for you, what type of Informatica connection are you using? When you say the records are "perfectly fine" what exactly do you mean by "perfectly fine"?&nb...
2212 Oct 2011 @ 11:01 PDTDatabaseReplyhow to make Compression Equal?! Is the PI and partitioning the same on the source and target tables?  What version of Teradata are you running this on?  
2122 Sep 2011 @ 02:21 PDTGeneralReplyHelp with COLLECT STATS The Teradata Optimizer is a cost based optimizer. It builds the execution plans and picks the "cheapest" one it can find.  Collecting statistics is like putting "price tags&q...
2022 Sep 2011 @ 03:30 PDTDatabaseReply'Materialized View' in Teradata? The only way to "freeze" the data in a view that I'm aware of, is to insert it into a table of its own. create table db.table as (select .... from db.view ...
1914 Sep 2011 @ 07:37 PDTDatabaseReplyUnique secondary index violation error The secondary index is a NUSI, you didn't specify it as unique.  I'd check the data that your loading, it sounds as though your column combination on the PK (col1,col2,col3) is not ...
1805 Aug 2011 @ 09:29 PDTToolsReplyNumeric overfloweither your sum(sd.wghtd_orngl_val) exceeds 999999999999.999999 or the count(sd.srv_accs_id) exceeds the maximum value storeable in decimal(18,6)...try expanding your casted datatype targets from...
1720 Jul 2011 @ 07:16 PDTUDAReplyKey Level DuplicatesAshok's response first: simply include all the rows if its a not a very wide table and add all rows to the group by and specify having count(*)>1, this will show you the duplicate rows and their p...
1620 Jul 2011 @ 06:31 PDTDatabaseReplySQL QueryIt could be the option(s) you've got set in your SQL Assistant. Select Tools, Options, Answerset and uncheck the "Display 1000 separator in numeric columns" check box.
1520 Jul 2011 @ 03:54 PDTUDAReplyKey Level Duplicatesdid you try something like... select key_field_1 ,key_field_2 ,count(*) from table_a having count(*)=1 group by 1,2 --for the non duplicates, if you'd like to find the duplicat...
1408 Jul 2011 @ 09:30 PDTDatabaseReplyFinding freq of a qrydbql also has a column named collecttimestamp, this column along with some sql magic should get you what you want...
1306 Jul 2011 @ 06:53 PDTUDAReply TIMESTAMP in TeraDATAAlternatively, you could also change your where clause to read where update_dts between '2009-01-16 00:00:00' and '2009-01-31 23:59:59' this change may also improve the performance of your q...
1223 Jun 2011 @ 06:05 PDTDatabaseReplyUse of Multiset tables?The temporal features of TD13.10 require the use of multiset tables to house pseudo duplicate rows. Temporal tables also require the use of a NUPI, as the same primary index may occur in multiple ...
1105 Jun 2011 @ 12:55 PDTToolsReplyTPT script loading issueIf you're using the load operator, it is analagous to fastload, which discards any rows that are duplicates. Check the data set your trying to load...
1029 May 2011 @ 09:01 PDTToolsReplyData modelling for TeradataThe best modeling tools for Teradata that I've seen are the Embarcadero tool and ErWin. Depending upon what you're trying to do, I'd take a good strong look at Wherescape Red as well. Though not ...
921 May 2011 @ 08:16 PDTGeneralReplywithout 'LIKE'?how about something like .... select column1 from table1 where substring(column1 from 1 for 1) ='b'
828 Apr 2011 @ 07:06 PDTToolsTopicTPT load or update into a Global Temp TableWe have to encrypt sensitive data in the etl stream, using a global temporary table as a "staging" table provides session local exposure of the data, I would like to load or update into the global ...

Pages