#DateForumTypeThreadPost
12125 Oct 2013 @ 04:04 PDTData ModelingTopicJoin indexHi,   I have 3 qs:   1) Can we have JI for queries having subqueries?     2) Created JI on two tables joining a PI and non-PI and found that group amp is not ...
12024 Oct 2013 @ 11:12 PDTDatabaseReplywhich fields is populated which is empty in a tableHi Vince, I think your plan B won't take time , if you know how to automate the script and using excel together :) , if you are comfortable with excel script. It is just a few minute's wor...
11923 Oct 2013 @ 11:27 PDTToolsTopicTLE disabledHi, Can anyone help me to explain why TLE should be disabled by default and should never be enabled on a production system.   Thanks and regards, Raja
11823 Oct 2013 @ 11:17 PDTToolsReplyNeed to include column heading in Teradata Bteq script Hi, you can use thus:   .SET TITLEDASHES ON .EXPORT REPORT FILE= /pmretl/data001/SessLogs/RXDM/market_data.csv SELECT VNDR_SRC_MRKT_ID,DATA_SRC_ID from GHHUSDW_PMR_STAGE_ETL.SRC_...
11723 Oct 2013 @ 11:04 PDTDatabaseReplyCount Days in a date fieldHow about  select count(extract (DAY FROM B.last_pmt_txn_dt))  from tab1. I am not sure, why you need to extract a day in order to count date.   Cheers, Raja
11623 Oct 2013 @ 10:49 PDTDatabaseReplyTranspose rows to columnsHi,   The column limit for Teradata is there. As far as I know it is 2048 columns. Please check. Also check the design :) . There are assorted implications. Cheers, Raja
11523 Oct 2013 @ 01:12 PDTGeneralTopicMacro ...stored procedureHi,   Can I say that a macro or stored procedure , a transaction? Please explain how. Thanks and regards, Raja
11421 Oct 2013 @ 04:44 PDTDatabaseTopicStatic partition eliminationHow does a static partition elimination happen for a query? Does it mean that for all queries, Optimizer makes a plan by using built-in function or USING request modifier? Thanks and regards, Raja
11318 Oct 2013 @ 11:36 PDTGeneralTopicQuery Rewrite The context I am asking is about a scalar query with  inner joining and outer joining .   In Query Rewrite, when it pushes projection into views, I understand like in Relationa...
11217 Oct 2013 @ 04:16 PDTDatabaseReplyMigration from Oracle to Teradata Teradata has varchar data type.The maximum for latin is 64000 and unicode is 32000. As far as I remember NVARCHAR in oracle is good to convert to UNICODE. Please check.     ...
11117 Oct 2013 @ 03:03 PDTCloud ComputingReplyCloud features Service of software applications by way of network such as internet. Connections and resources are made or shared from computers to computers.Prominent services are Software as a Service,Platfor...
11017 Oct 2013 @ 12:38 PDTGeneralTopicTVS Hi,   I am interested to know how the shared-nothing architecture still exists when a storage pool interfaces between cliques and AMPs. Will the allocation units  be evenly...
10915 Oct 2013 @ 03:57 PDTDatabaseReplyCLOB In Teradata ? Nishant, you may use/ run program in ab initio , create a unix script that calls bteq....     .IMPORT INDICDATA FILE=...........; USING (xxxxxxx INTEGER, yyyyy CLOB ..........
10815 Oct 2013 @ 03:44 PDTDatabaseReplyTypes of locks during Fastload abort-?Nishant, I will answer from my viewpoints :). Fload is built for fast loading into empty tables. Mload is built with 5 phases...blah blah.. So you see the differences. Both utilities are built for ...
10715 Oct 2013 @ 12:47 PDTUDATopicReserved Query bands for BLC and Storage temperature I am curious about the reserved query bands for BLC and storage temperature of newly loaded data. I think they can be used by all. Do they come with separate licenses? May I know the cost and th...
10614 Oct 2013 @ 11:15 PDTDatabaseReplyIs there anyway to compare the contents of tables on two different TD instances?I will not suggest you have entries in both prod and test :). Anyone in that case can tamper costly production data. You can take the prod data thru fastexport and then fload to test and then do a ...
10511 Oct 2013 @ 04:17 PDTDatabaseReplyWorkload Management & Capacity Planning   You have placed so many questions :). However, let me try to share few on database capacity planning based on your question so that in can  give evaluation or hint on cost-cu...
10410 Oct 2013 @ 11:44 PDTDatabaseReplyFetching data in chunks using query in teradataHi, Using query, you can limit with where and qualify and even row_number based on your requirements. I think you can elaborate your requirements more :). Teradata has bteq ( import, export), mlo...
10309 Oct 2013 @ 12:31 PDTDatabaseReplyCasting to An integer giving incorrect result.Hi Dieter, I feel the best test is to do in Unix or Linux environment. Please let me know your views. Cheers, Raja
10208 Oct 2013 @ 05:44 PDTData ModelingReplyRow header Hi Jake, Thanks for a quick respone. Now if I have this table say 100000 records: ct abc( id integer, dob date, sex char(1), status char(2), trans_date date)...... I want to know in Teradata 14,...
10108 Oct 2013 @ 04:48 PDTData ModelingTopicRDBMS vs network vs hierarchicalHi, I am at a loss for this simple question? Is RDBMS technology-driven,business-driven,enterprise-driven or system-driven? Any help with reference to reliable source or document or book is appr...
10008 Oct 2013 @ 04:23 PDTDatabaseTopicRow size ----columnarTransfering my question from modeling to database forums I am curious about the row header. I assume my understanding is right. The rowid is 128 bits. 64 bits internal partition number, 16 or 20 ...
9908 Oct 2013 @ 02:31 PDTGeneralTopicUnity Director Vs Oracle Golden GateHi, Can anyone help me to understand the capabilities of Unity Director Vs Oracle Golden Gate?    Thanks and regards, Raja
9808 Oct 2013 @ 12:56 PDTAnalyticsReplyRunning query under certain conditionHi, I am not very clear about your requirement but I can suggest we can use a combination of small Unix scripting and Teradata combination. Have an automatic script that runs the count from the da...
9708 Oct 2013 @ 12:43 PDTAnalyticsReplyTeraData Tuning Teradata is so rich to solve business cases and for each case, you have many options to choose.   It boils down to the way how your warehouse is built, suiting the business. If ...

Pages