#DateForumTypeThreadPost
3301 Dec 2010 @ 02:06 PSTDatabaseReplyTranspose IISee the following thread, it might help you. http://forums.teradata.com/forum/analytics/transposing-data
3229 Nov 2010 @ 12:25 PSTDatabaseReplyNeed help handling null and empty valuesif there are some empty characters then it will be treated as 0 length string. Right? eg INSERT INTO table (MyField) VALUES (' '); SELECT LENGTH(MyField) FROM tab...
3125 Nov 2010 @ 10:45 PSTDatabaseReplyWhat is Master Index and Cylinder Index ?Teradata uses logical address system, unlike other DMBS which uses physical address systems. This allows teradata to locate the data easilly even if the data gets reallocated/defragmentated. MI an...
3025 Nov 2010 @ 10:33 PSTUDAReplyTeraData vs OracleA very good discussion and just want to add my little knowledge into it. Teradata is different from other DMBS (like Oracle) because it uses logical addresses rather than physical addresses to sto...
2922 Nov 2010 @ 11:19 PSTDatabaseReplyteradata and oracle architectureIn oracle (G versions) there is a full support for parallelism. Then what is the difference between the two? Is oracle (G versions) based on MPP? By the way there is no attachment.
2822 Nov 2010 @ 11:14 PSTDatabaseReplyConditional statement in Teradata macroAs CarlosAL said "Macros are just SQL sentences". You can not create or execute procedures using macros. You can create a macro that will reproduce your procedure body but still you need to execute...
2710 Nov 2010 @ 01:21 PSTGeneralReplyTeradata variable/view/macrocheck for "DBC.SYSEXECSQL" for more on how dynamic SQL works.
2605 Nov 2010 @ 03:30 PDTDatabaseReplyDynamic Date Calculation in SQL QueryTo get the last day, you can also try select add_months(current_date,1) - extract(day from add_months(current_date,1));
2530 Sep 2010 @ 09:26 PDTDatabaseReplyAdding time feildstry this: select cast(cast(endTime as time) - cast(Starttime as time) as time)
2413 Sep 2010 @ 11:53 PDTDatabaseReplyRegarding Fast Load utilityThe first thing that come immediately in my mind is that fastload works with SET table only. So there might be duplication in the records coming in your file.
2319 Aug 2010 @ 01:08 PDTDatabaseReplyto change the titleIs this an index field? If not then you can use RENAME sql to get the desire result, as ALTER TABLE tableName RENAME oldColumnName TO newColumnName;
2227 Jul 2010 @ 04:18 PDTDatabaseReplyHelp With JoinsBut in that case it won't be a dynamic query eg if you have a third record against 100 in address_table then it won't fetch it using two left joins, rather for that you need to use three left joins...
2127 Jul 2010 @ 12:23 PDTDatabaseReplyHelp With JoinsDo you really want to do it with SQL? This is a presentation level function, so it should be handled by your tool use for presentation.
2023 Jul 2010 @ 12:33 PDTDatabaseReplySpool treatment for DISTINCT versus GROUP BYThe contents of the link is not in English. Do you have an English version of it?
1928 Jun 2010 @ 02:53 PDTDatabaseReplySubquery VS Derived TableOkay it means that whenever we ues a query in the FROM clause, we would be referring it as a dervied table because we would be accessing the fields in the outer query from the one in the FROM claus...
1828 Jun 2010 @ 02:40 PDTDatabaseReplyShow tableSorry but i didn't find Alternate text in DBC.Tables.
1723 May 2010 @ 10:05 PDTDatabaseTopicSubquery VS Derived TableHi All, What is the exact difference between subquery and derived table. I read somewhere that if a query is use in: > SELECT than its a subquery > FROM than its a Derived table > WHERE than i...
1606 May 2010 @ 08:59 PDTGeneralReplyYour forum history This is always a fascinating feature for me, while using any forum because this gives me an ease of tracking my posts/replies. I was looking for the same kind of thing in Teradata forum but couldn...
1529 Apr 2010 @ 09:15 PDTDatabaseReplyUse of a Primary IndexFirst to clear about your concept regarding primary index. Teradata primary index: > is use for data distribution among the AMPs > there is always one index in a table and it is must for every ta...
1423 Apr 2010 @ 02:09 PDTDatabaseReplyWhen does outer join become inner?Which outer join are you talking about? > LEFT: left outer acts like inner join when all the match from left table is found in the right table > RIGHT: vice versa of LEFT > FULL: full outer join...
1321 Apr 2010 @ 01:55 PDTDatabaseReplyJoin On String Ignore Casewhat does CS meant for?
1220 Apr 2010 @ 02:50 PDTDatabaseReplyMERGE vs UPSERTi think this really clear my concept regarding UPSERT and MERGE thanks all.
1119 Apr 2010 @ 10:53 PDTDatabaseReplyMERGE vs UPSERTUPSERT is only the concept and MERGE is the implementation of this concept. Right? I found MERGE syntax in many places but could not able to find any syntax for UPSERT thats probably because an ...
1019 Apr 2010 @ 02:02 PDTDatabaseReplyDifference Between Drop & Disabling the IndexI am not sure which index are you talking about. > If you are tallking about PRIMARY INDEX then you can not drop it, if data is loaded. Primary index is created at the time of table creation and i...
917 Apr 2010 @ 10:22 PDTDatabaseReplyMERGE vs UPSERTOkay so teradata supports both but still can understand that whats the difference between the two?

Pages