#DateForumTypeThreadPost
7906 Nov 2013 @ 09:00 PSTToolsReplyProblem Loading Multibyte Characters In Teradata Using FastloadHi Feinholz, Thanks a lot for the insight Now if i were to get 'F09F94B0'XC in my file instead of <d83d><dd30> will then i be able to use fastload and load the tabl...
7805 Nov 2013 @ 10:57 PSTToolsReplyProblem Loading Multibyte Characters In Teradata Using Fastload  Hi Feinholz,   Thanks for your response here's a sample of how the data looks when you vi the output file  from infa in unix (mac)   879987...
7702 Nov 2013 @ 08:15 PDTToolsReplyProblem Loading Multibyte Characters In Teradata Using FastloadHi All, Can anyone please help me with the above ? Thanks R.Rajeev      
7601 Nov 2013 @ 06:42 PDTToolsReplyProblem Loading Multibyte Characters In Teradata Using Fastload  Hi, The emoji characters look like the one in the following link http://www.charbase.com/1f530-unicode-japanese-symbol-for-beginner I am not able to paste the charatcer in the forum henc...
7501 Nov 2013 @ 06:36 PDTToolsTopicProblem Loading Multibyte Characters In Teradata Using Fastload  Hi All,   I am finding it difficult to load multibyte data using fastload    Some of the columns in our source are containing graphic characters like emoji...
7422 Aug 2013 @ 07:03 PDTDatabaseReplyMigrating From Oracle To Teradata Help With DDL GenerationHi , Thanks Adeel  
7321 Aug 2013 @ 07:15 PDTDatabaseReplyMigrating From Oracle To Teradata Help With DDL GenerationHi, Thanks Aravind The client is not willing to add another client tool that leaves us just with oracle,infa and TD (database) Is there any other way or logic which we can follow ? Thanks R.ra...
7217 Aug 2013 @ 01:59 PDTDatabaseTopicMigrating From Oracle To Teradata Help With DDL GenerationHi All, As part of my current project there is a need to migrate a number of tables from Oracle to Teradata, i would like to know if there is some sort of an automated way using which once could ...
7102 Jul 2013 @ 07:13 PDTTeradata StudioReplyUnable To Create Stored Procedure Using JDBC !!Hi All, Thanks for the responses Charles you were right , i tried after granting the create procedure access on the database DB_1 to the user DBC and it worked !! I had created DB_1 and the tab...
7029 Jun 2013 @ 10:15 PDTTeradata StudioTopicUnable To Create Stored Procedure Using JDBC !!Hi All, I have downloaded and installed the TD-13 express version using VM player I am able to query the database and everything looks fine, however when i try to create a stored procedure it jus...
6909 Apr 2013 @ 03:53 PDTDatabaseReplySpace consumed by Primary IndexHi Sudipta, Primary Index don't cost you space unlike the secondary indexes which maintain the sub tables Regards R.Rajeev
6804 Apr 2013 @ 04:12 PDTUDAReplyfastloadHi , As per my understanding the fastload has 2 phases begin loading and end loading, now where is the data stored at the end of the begin loading phase in case of multifile load i have noticed t...
6702 Apr 2013 @ 04:03 PDTDatabaseReplyStored Procedure Vs BteqHi Sudheer Thanks for getting back ! Yeah i understand Bteq is a tool but what i meant was a comparison of the Bteq scripts and SP there are things which can be accomplished using both a Bteq sc...
6630 Mar 2013 @ 08:29 PDTDatabaseReplyValue ordered NUSIHi Moutashi, As i said first all NUSI operations are all amp be it value ordered or non the advantage lies in reading the data out of subtable. Terdata works in parallel so it doesnt matter if da...
6529 Mar 2013 @ 03:09 PDTDatabaseReplyValue ordered NUSIHi, NUSI is always an all amp operation but not a full table scan. So it will first ask the subtables on all the amps and querying this subtable based on a non eqality condition as it ...
6427 Mar 2013 @ 07:41 PDTDatabaseReplyStored Procedure Vs BteqHi All, Any help on the above would be very useful. looking forward Thanks R.Rajeev  
6326 Mar 2013 @ 07:21 PDTDatabaseReplyquery for getting elapsed timeHi MBR, May be you can find more informaion in the following link- http://forums.teradata.com/forum/database/calculating-the-actual-query-run-time#comment-26312 and also let us know if you find ...
6226 Mar 2013 @ 07:19 PDTDatabaseReplySpool v/s temporary spaceHi Just adding a point- from TD-13 onwards one collect stats for volatile tables as well      
6126 Mar 2013 @ 12:22 PDTDatabaseReplyStored Procedure Vs BteqHi All, Can anyoone please provide some insight on the above question looking forward !! Thanks R.Rajeev
6025 Mar 2013 @ 03:06 PDTDatabaseTopicStored Procedure Vs BteqHi All, Could any one tell the advantages and disadvantages of using SP and Bteq basically a comparison of both and the scenario when one is prefered over another My general understanding is the...
5911 Mar 2013 @ 07:10 PDTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentHi Ashish, I think its explained above by emilwu, one can use recursive queries to achieve the concatenation heres another example- Assuming that tb1 is the table conataining your data create m...
5810 Mar 2013 @ 05:24 PDTDatabaseReplyTimestamp format not working to get the two digit yearHi Rafi, Yes, as Nishant pointed out an approach using recursive queries would be a more generic one here is an eaxmple- Assuming tb1 is the table containing data we need to make tb3 to rank the...
5709 Mar 2013 @ 09:48 PSTDatabaseReplyIs it good to creating SET table with UPI or NUPI and why..?Hi Its better to create a SET table with a UPI or enforce uniquness on atleast one of the columns if not on the PI columns. SET tables dont allow duplicates however if you are deifining a NUPI t...
5609 Mar 2013 @ 07:18 PSTDatabaseReplySpace in the databaseHi All, Someone please help me in validating the two queries Thanks in advance Regards R.Rajeev  
5507 Mar 2013 @ 06:53 PSTDatabaseReplySpace in the databaseHi All, Could anyone review the above two queries and let me know of any mistakes Thanks R.Rajeev

Pages