#DateForumTypeThreadPost
5315 Mar 2016 @ 12:51 PDTDatabaseReplyTPT load in informatica giving CLI ErrorThanks Fred !! Appreciate your response and time.
5210 Mar 2016 @ 09:56 PSTDatabaseReplyTPT load in informatica giving CLI ErrorThanks Fred !! Our Linux server's  THREADONOFF  is set to 1 (THREADONOFF=1) .  Followings are our COPERR settings. Is there anything to do with Maxsessions settings for each job ...
5109 Mar 2016 @ 10:24 PSTDatabaseReplyTPT load in informatica giving CLI ErrorHi Suzi.Limberg, Have you resolved the issue? If  you got a resolution can you please share? We are getting the following Error from Informatica 9.6 to Teradata TD15.0 connection. The jobs ru...
5020 Mar 2008 @ 01:25 PDTUDAReplyHow to get Output as a pipe delimited file?you may use code like this too.select cast(CUST_ID||'|'||CUST_NAME||'|'||......UPDATE_DATE||'|'||UPDATE_TIMEas char(250))---(must be big enough to hold all columns plus commas)from CUST
4918 Mar 2008 @ 03:27 PDTUDAReplyExclusive LockFor a delete/insert task I donot think they should put an exclusive lock. If they are concerned about dirty read inbetween delete and insert they can put the code inside BT/ET block.something like...
4818 Mar 2008 @ 12:05 PDTTrainingReplyWhere to I can start?1. Read the introduction manual.http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy-Results.cfm?pl=&PID=&title=%25&release=&kword=INTRO&sbrn=7&nm=Introduction+to+Teradata2. Read the SQL ...
4714 Mar 2008 @ 11:26 PDTDatabaseReplyRandom Number GeneratorYou may have a larger range between lower and upper limits to create almost unique values ( generally 10 times of the rows). RANDOM function is activated for each row processed so you cannot gua...
4605 Mar 2008 @ 05:02 PSTUDAReplyQuery Performance Optimization HelpI presume all the joining columns are part of PI in both the tables. From an excerpts of a post from Mr. Dieter ( a supreme supreme being) I remember that COALESCE on nullable PI columns results ...
4505 Mar 2008 @ 03:55 PSTDatabaseReplyHash JoinsPartial reply to your questions and would be looking for other's input.If the join column(s) are PI of both the tables, a merge join will perform best. ( No data redistribution or data sorting is n...
4421 Feb 2008 @ 11:10 PSTUDAReplyCollect Stats n Refresh StatsQ. what is meant by .....no residual conditions into Spool 1Ans: All applicable conditions are applied.Q. and (group_amps)???Ans: A subset of AMPs will be used instead of All AMPs.Q. Note : collect...
4315 Feb 2008 @ 01:41 PSTDatabaseReplyCollect StatsSee my answers... hope that helpsQuestion: Also,Let me know...once a collect stats is done are all those records stored somewhere? i.e If a collect stats on a table is resulted with 10 unique value...
4214 Feb 2008 @ 01:26 PSTConnectivityReplyCONVERT MERGE STATMENT INTO UPSERT STATMENTYou can use Update & Insert strategy in place of MERGE INTO. However, merge into is also valid syntax in Teradata. I am not sure why you need change the Merge into this but you may use something ...
4112 Feb 2008 @ 05:03 PSTDatabaseReplyCollect StatsHere is my answers, hope that helps: 1: Once a collect stats is done on the table(on index or column) where is this information stored so that the optimizer can refer this?Ans: Collected statistics...
4011 Feb 2008 @ 01:01 PSTDatabaseReplyneed data between selected datesCould you post the error that you are getting? Are you passing those dates as parameters?
3923 Jan 2008 @ 03:21 PSTUDAReplySlow CoalesceCould you take a look how the tables pa11, pa12, pa13,pa14,pa15,pa16, pa17, pa18, pa19, pa110 & pa111 are joined before joining to a112 ? I suspect join condition/s are missing and the query bec...
3823 Jan 2008 @ 02:01 PSTDatabaseReplyCross join V/s Product JoinCROSS JOIN is a type of joins and product join is a join plan chosen by the optimizer. In product join, total comparisions are multiplication of qualified rows from both the participating tables.R...
3714 Jan 2008 @ 01:41 PSTDatabaseReplyLT,WT,ET,UV tablesJeevan,My apology to you if my comment offended you anyway. My intension was to make you aware of your signature and not to underestimate your question. My second line was totally uncalled for and ...
3611 Jan 2008 @ 04:05 PSTDatabaseReplyLT,WT,ET,UV tablesNo offense, in one hand you are saying you are new to Teradata but your signature says you are Teradata Certified Designer. By the way, there is no certification called Teradata Certified Designer ...
3510 Dec 2007 @ 01:42 PSTUDAReplyIs there a option of creating control files when exporting DataUsing Fast Export,you cannot generate a control file in the same job. If your data volume is low, you may use a BTEQ job which you can use to generate your control file and data file in the same j...
3410 Dec 2007 @ 01:25 PSTToolsReplyError getting in executing TPUMP with InformaticaIs your TPUMP job wrap around a wrapper script? If so please take a look at your parameters list in the wrapper script and the parameters you are passing.
3310 Dec 2007 @ 01:17 PSTDatabaseReplyHow to get weekly summarized dataDo you have a Fiscal Calendar table to join with your base table? If not, Join your base table with SYS_CALENDAR.CALENDAR table to get the week_of_Calendar field for each DATE in your table. Now ha...
3207 Dec 2007 @ 04:30 PSTDatabaseReplyDenormalize a tableIf your COL_C is a numeric field and there is a limited combination of COL_A, COL_B & COL_C in table 1 then you can use this principle....Insert into Table2Select A.COL_A, A.COL_B, SUM(COL_C), SUM...
3105 Dec 2007 @ 01:44 PSTUDAReplymultiple Inserts into same table from different sourcesIf your CUST table allows duplicate row ( no UPI or USI is created to enforce data integrity and the table was created as Multiset table) then your query will work. But as someone has already poin...
3005 Dec 2007 @ 12:43 PSTAnalyticsReplyHow to import data from Excel fileThere are quite a few posts on this topic. Please search the forum with key word 'import'.
2904 Dec 2007 @ 10:06 PSTDatabaseReplyHow This code works?First it is finding the starting position of substring 'BETWEEN DATE' using index function then adding 13 to get the starting position of the first Date range , then reading 12 characters from ther...

Pages