#DateForumTypeThreadPost
2502 Jan 2016 @ 09:54 PSTTeradata ApplicationsReplyPerformance tuning questionThanks for the reply.   I've a question-  I think you said to create a second level parition on source syserm id where as my major partition would remain  on Transacti...
2402 Jan 2016 @ 09:14 PSTTeradata ApplicationsTopicPerformance tuning question SELECT TRAN_ID.SRC_TRAN_ID, TRAN_ID.SRC_SYS_ID, TRAN_ID. SRC_TRAN_DT, TRAN_ID.TRAN_ID, TRAN_ID.ROW_STAT_CD FROM RD_GBS_WIR RD INNER JOIN TGT_TRAN_ID TRAN_ID ON RD.SRC_TRAN_ID =TRAN_ID....
2328 Feb 2015 @ 04:06 PSTDatabaseReplyQuestion on Aggregated Join IndexGernally we use Partition column in where clause if we query on paritioned table. To use that advantage, we can make AJI also paritioned. it would be useful when AJI also has lot of recor...
2228 Feb 2015 @ 03:51 PSTDatabaseReplyIssue during import text data in to table using sql assistantHope you have verified the delimiter set in the import setting(options->export/import) if it matches the exact delimiter in your text file.
2128 Feb 2015 @ 03:48 PSTToolsReplyBTEQ field separator.After you follow Fred's suggestion, if you still have the issue, can you share your export and select command to verify. It would be easy if you can provide the log also to identify t...
2023 Nov 2014 @ 03:29 PSTAnalyticsReplyairlines query - cross value duplicate eliminationYes. Thanks Raja and Dieter.
1922 Nov 2014 @ 05:51 PSTToolsReplyPDCR InstallationProbably it is an access issue.  Check with your admin to grand crontab edit access
1822 Nov 2014 @ 05:49 PSTDatabaseReplyHow to decide about Stats for new queriesThrough explain plan recommondations after executing "diagnostic helpstats on for session" . Generally multicolumn stats only used when that combination of columns are used in ...
1722 Nov 2014 @ 05:45 PSTToolsReplyWhere I can find Teradata Tools and Utilites 14.10?Yes you can install vmware player and download the teradata demo VMware images and play them in your system to practice. 
1622 Nov 2014 @ 05:40 PSTDatabaseReplyHow to decide about Stats for new queries"complete table" you mean all the columns of the table ? No it is not required to collect all the columns of any table. Only those columns of any table invloved in where , joins..etc &...
1522 Nov 2014 @ 05:20 PSTAnalyticsTopicairlines query - cross value duplicate eliminationHi Experts, Can you please help me logic on below - a table has source , destination and distance. There are some rows where destination was already there as source in some other record...
1421 Nov 2014 @ 03:10 PSTDatabaseReplyJoins involving Partitioned PIsIf non PPI table is also being used very frequently  in such range queries, better propose PPI for that table also. If range query is occasional and PI usage is more, better live with PP...
1321 Nov 2014 @ 03:04 PSTToolsReplyWhere I can find Teradata Tools and Utilites 14.10?Welcome !! Just wanted to add, see the IP of your demo server (could be 14, 14.10 or 15) create the DSN in your local machine.   (I faced problem when i was using localtd as my host name...
1221 Nov 2014 @ 03:00 PSTDatabaseReplyOptimization with JOIN conditionIs B.DLOF_ID_NO_RU also primary index in the second table B? (Then why JI is required?) Are the data types of both the column involved in join same ? is second table has any partion added and see ...
1121 Nov 2014 @ 02:54 PSTTrainingReplyAny best Training Centres you guys know in Hyderabad??Hi Akshay, I was also in same situation when i moved to Teradata project. I did my research and asked in forums (you may see my post in the same page 2 monts ago).  The experts here have given...
1021 Nov 2014 @ 02:31 PSTDatabaseReplyHow to decide about Stats for new queriesThanks Dieter for the links. They are informative. Gian, What I mean in my above post was  - The number of steps may increase or decrease some times. But need to see if any change and t...
918 Nov 2014 @ 06:45 PSTToolsReplyWhere I can find Teradata Tools and Utilites 14.10?For practice purpose I installed 15.0 utilities from below  - https:/downloads/teradata.com/download/tools/  and then select TTU windows install   (i'm not able to paste...
818 Nov 2014 @ 06:36 PSTDatabaseReplyHow to decide about Stats for new queriesBelow is an extended list of candiate columns of stats collection in general - where clause columns Index columns (Preferebly NUPI, NUSI, partitions, JI), columns which are involved in join...
718 Nov 2014 @ 06:12 PSTDatabaseReplyJoins involving Partitioned PIsin the PPI table the rows order with in each AMP is different than the PI table. So even with samp PI join if one of the table is PI and another is PPI it degrades the performance. If you join on ...
605 Nov 2014 @ 09:19 PSTDatabaseReplyTPT errorGuessing ---  'ID' is being considered as keyword and so it is failing. Can you check by making it with different name if it works.
517 Oct 2014 @ 10:01 PDTJobsReplyTeradata training ..Hi, I'm also new to terdata world.  started searching for teradata trainings. Dowloaded express version and configured for practice. Got some useful stuff through Education Network&...
418 Sep 2014 @ 06:57 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??ok. let me check. I see many feedback favour to Manohar with original profiles. I connected with them. Not sure who is favouring whome. I'll take a cautious decision. and post my feedback aft...
304 Sep 2014 @ 12:38 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??Sure Srikanth. will keep your suggestions in mind.  I sent an email to sunmanu9@gmail.com . He responded back with his course curriculum and some sample videos in youtube (saw the feedback...
201 Sep 2014 @ 12:12 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??Thanks .   Let me also try. Thanks again for valuable inputs.
131 Aug 2014 @ 07:37 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??Hi, I am new to teradata and need to work on a teradata project soon. Can any one help me a best way of learning quickly. -satyanarayana-