#DateForumTypeThreadPost
9008 Jul 2014 @ 12:59 PDTDatabaseReplyCan we able to perform all the ETL activites by using VIEWS ?????Usage of the views by ETL team will not help improve your query performance. Usage will only help in avoiding deadlock situations and will allow 2 concurrent queries on a single table. The DBA need...
8908 Jul 2014 @ 08:32 PDTGeneralReplyOne of the fast Export session has been logged offhow long has the export ran before it throws out the error that one of the session logged off? Usually it so happens that when a export is run with multiple sessions, only one of them will be inact...
8808 Jul 2014 @ 08:14 PDTGeneralReplyHow to start teradata service in suse linux vmware image (teradata express 13.0)BTEQ needs to be first installed on a windows/unix machine. Once you have installed that, in any directory(mostly in the directory where you have your code file) you can start executing by entering...
8702 Jul 2014 @ 01:57 PDTGeneralReply3707 error expecting something like')' between a string or a unicode charecter literal and ;Unless you are joining 2 tables * does not allow a comma to follow it. Hence TD is expecting a || . what is NVP??
8630 Jun 2014 @ 02:43 PDTToolsReplyConcurrent Load to same table (MLOAD fails - can TPump be a solution or what is a solution?)TPUMP can be a solution as long as your data size is not too big. The processing would be slow as TPUMP would be a row based operation. You can define the view as replace view dbname.viewname lock...
8530 Jun 2014 @ 09:22 PDTDatabaseReplyUpdate statment update b  from dup_test b,(sel site,part1,part2,part3,mfg_date,rank ()over (partition by site,part1,part2,part3 order by mfg_date desc) rnk from dup_test qualify rnk<>1) a set upd...
8430 Jun 2014 @ 08:33 PDTDatabaseReplyAccess Rights Validation PerformanceAccessing through Roles is always considered to be better. In an environment where the number of users and the number of objects are more(which is usually the case with Teradata), it is always bett...
8330 Jun 2014 @ 07:44 PDTGeneralReplyHow can we rectify spool space issues.Have you tried verifying if there is any left over spool(spool that is not released) for the user being used. i see that you are using a file and is a straight dump into the table. As Raja asked,wh...
8230 Jun 2014 @ 07:30 PDTToolsReplyConcurrent Load to same table (MLOAD fails - can TPump be a solution or what is a solution?)Please try using the following: 1. Create views on top of the base table and start using view layer to load the tables. 2. you have Tenacity and sleep options in informatica and can set these par...
8109 May 2014 @ 02:52 PDTDatabaseReplySlowness in Teradata systemif the health of the system is normal and the cpu utilization is not too much, can you check if there are any hardware array disk failures on the system. is your system an appliance version or ente...
8009 May 2014 @ 02:40 PDTToolsReplyModifying idle timeout for SQL Assistant?There is a system level setting that will be done in which case sessions which stay idle beyond a certain amount of time will be aborted.
7909 May 2014 @ 12:48 PDTToolsReplyModifying idle timeout for SQL Assistant?what is the time that you are seeing this happening?During this time is the system getting suspended/hibernate  which i do not think would happen. Ask your DBA if there is any session tim...
7801 May 2014 @ 10:51 PDTToolsReplyBTEQ Batch Mode LogonHave you created the user jugal. if done try removing the password and enter it when prompted.
7728 Apr 2014 @ 01:34 PDTGeneralReplyWhat is the difference between Secondary Index and Join index? Hariharan, Conceptually both of them are in no way comparable. Secondary index provides an alternate path to reach the base data in a table. There is a subtable built on top of the actual table wh...
7625 Apr 2014 @ 08:55 PDTGeneralReplyUtilising Wasted Space in TeradataThe more of wastedSpace over actualSpace is an indication of the table's skew. For the tables with more wasted space, identify primaryindex,count(*) and you will see that the PI repeated values...
7522 Apr 2014 @ 09:50 PDTDatabaseReplyNeed Help on Below Senario ? sel a.id,a.base_code from ( sel id,base_code,case when base_code in ('03','04') then '03' else '01' end as ind from dbname.tablename ) a where a.ind='03' ...
7422 Apr 2014 @ 09:32 PDTDatabaseReplyRow Hash and number of unique values for primary index  It is not that you can have only 2^32 (4.2 Billion)values for a UPI. The hashing is primarily to indicate the AMP onto which a row should be distributed into. There can be more than 2^32 va...
7322 Apr 2014 @ 09:06 PDTDatabaseReplyAlternatives to Like/Like Any (case when ((targeting_region like '%targ=%') and (targeting_region  like '%targ=!%')) then 1 else 0 end) as target_flag Do you want only the 1st row to be displayed when yo...
7221 Apr 2014 @ 03:25 PDTGeneralReplyCase statement with multiple elseAssigning two values for a single column will not be possible. There should be a condition(s) for either  I or U.
7121 Apr 2014 @ 11:02 PDTGeneralReplyCase statement with multiple else case when substr(bill_cyc_cd ,1,1) = 'B' and acct_typ_cd = 'C' then 'Y'  when substr(bill_cyc_cd ,1,1) = 'G' then 'Y'  else 'N' ...
7021 Apr 2014 @ 10:14 PDTDatabaseReplyIdentify Set - Multiset Tables in TD 14The dbc.tables gives the last statement which modified the table but does not truly reflect the table definition. Instead as Adeel suggested, export the show table and do a search. I am not pr...
6917 Apr 2014 @ 08:26 PDTGeneralReplyNo Spool space errorAs i mentioned in the other post below, skew should not be the only factor deciding the PI but the higher the skew the more the time consumed for working on the skewed data. http://forums.ter...
6816 Apr 2014 @ 11:18 PDTDatabaseReplyHow to reduce skew factor on stage tables with NoPI?Tajmul, compressed columns are not allowed in the PI column list. you can have any number of columns to be defined as the PI but for choosing the better PI, the skew should not be the only factor. ...
6716 Apr 2014 @ 09:17 PDTGeneralReplyNo Spool space error sel hashamp(hashbucket(hashrow(col1,col2,col3))),count(*) from table1 group by 1 order by 2 desc; sel hashamp(hashbucket(hashrow(col1,col2,col3))),count(*) from table1 group by 2 order by 2 desc...
6616 Apr 2014 @ 09:00 PDTDatabaseReplyPartition Primary IndexAs all mentioned the size should not be the deciding factor instead get the query list over a table and the where clause being used, the join criteria and the frequency of these happening. if the p...

Pages