#DateForumTypeThreadPost
27102 Dec 2013 @ 01:54 PSTGeneralReplyScheduling a job in DBQLHi Omar, I usually use cron job, unix, which is quite handy for me. So what I do is put the scripts in unix(using bteq),it may be ksh I always use, then.  30 1 * * * /home/lastDayOfMth &...
27002 Dec 2013 @ 01:31 PSTDatabaseReplySelecting a column based on DATE along with GROUP BYHi Sagar, You mean to say you dont want this way below? select abc.u_id as gid,dt.mid from (SELECT MAX(date1) over (partition by gid order by gid) dt1,gid,mid,u_id FROM ABC) dt, abc where abc...
26902 Dec 2013 @ 12:48 PSTDatabaseReplyLoops without using proceduresHi, Can you please post in a proper format? There is a code button next to Paragraph. I think if you put in a format with 1) what you have and 2)what is your expectation , then response is faster....
26801 Dec 2013 @ 11:58 PSTGeneralReplyScheduling a job in DBQLHi Omar, I am always of the opinion that DBA will do it when needed. This link maybe helpful. http://d289lrf5tw1zls.cloudfront.net/database/dbql-scripts/TD13_0_and_TD13_10_DBQL_logging_and_maint...
26701 Dec 2013 @ 11:15 PSTExtensibilityReplyTeradata Integration with SalesforceHi Neha, I work on one project of cloud service where source is salesforce EDW and  semantic layer are Teradata. If you like then I can share some experiences. Cheers, Raja
26601 Dec 2013 @ 10:52 PSTExtensibilityReplyCall SP,bteq or shell script from a Java or C++ UDF?Hi, In c,c++, you need to have your specific header files and check them before implementing like example: #include <stddef.h>,#include <stdlib.h>,#include <stdio.h> . If you...
26501 Dec 2013 @ 09:54 PSTAnalyticsReplyImpact of using business Analytics on the business.Hi Aditya, Teradata has many solutions on this front like integrated marketing , marketing analytics, data management, multi channel campaign, asset management etc. Implementing business strategie...
26401 Dec 2013 @ 08:58 PSTData ModelingReplyNemo QHi, AFAIK, there is none. Just in case it may help you, please find the link below. http://forums.teradata.com/forum/data-modeling/financial-ldm Cheers, Raja
26301 Dec 2013 @ 08:26 PSTData ModelingReplyPPI VS NPPIYou are welcome.  Yes it is Column-Partitioned Tables, and Column-Partitioned Join Indexes. Cheers, Raja
26201 Dec 2013 @ 06:17 PSTThird Party SoftwareTopicSAP DS, Teradata utility model, geospatial loading to geolocator entityHi, While working on uLDM (project) ,loading data to geolocator table, having geospatial data types; SAP DS has strings source and coming blank in Teradata target table whcih has data type geospat...
26101 Dec 2013 @ 05:45 PSTConnectivityReplyLDAP Authorization and Simple BindsHi, Did you have a look at these links? http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1100_111A/title.088.2.html under security administration: ,ht...
26001 Dec 2013 @ 05:01 PSTData ModelingReplyPPI VS NPPIWe have NoPI tables. Also we can have table or join index  of column partitioned table that can have no Primary index. Cheers, Raja
25929 Nov 2013 @ 09:24 PSTGeneralReplyMVC ToolHi, I m just trying to evaluate the tools both(Prise and Atanasuite) if time permits. I dont know when I will get the download. I dont know if they covers all types of compressions (ALC,BLC,t...
25829 Nov 2013 @ 08:33 PSTUDAReplyHot Standby NodesHi Todd, Thank you very much. I think each HSN is attached to each clique. Thanks and regards, Raja
25729 Nov 2013 @ 08:28 PSTUDAReplyAppliance 2690 Hi Todd, Thank you very much. Regards, Raja
25629 Nov 2013 @ 08:22 PSTUDAReplyRelay Services GatewayHi Todd, Thank you for your time.  I think it is available on all platforms. Thanks and regards, Raja
25529 Nov 2013 @ 04:40 PSTGeneralTopicTeradata seminars and eventsHi, I want to attend Teradata's seminars, events, promotions etc. May I know how I can do? I heard that many people are having a good orientation programs regularly. Thanks and regards, Raj...
25428 Nov 2013 @ 11:31 PSTDatabaseReplyRe-writing a query interms of performanceHi, I think you need to revisit on PI (NUPI) selection , suiting the business requirement. Do you really need partition day wise? Cheers, Raja
25328 Nov 2013 @ 07:56 PSTThird Party SoftwareReplyBO Universe and TD MacrosHi, I have asked many BO experts ( colleagues) I know, they have never encountered such scenario. Are there any specific need of macros in  BO universe? So far, I have worked too, I never com...
25228 Nov 2013 @ 06:43 PSTDatabaseReplyCount the number of words in a phrase using Teradata SQLHi Sreechand, Sorry, I did miss  the subject line   :)  "...using-teradata-sql".. Here it is : SELECT (char_length('Hi How are you doing today') -char_length(...
25127 Nov 2013 @ 11:40 PSTDatabaseReplyRe-writing a query interms of performanceHi, I can see that the two tables have UPIs with only 1 column matching. Have you thought of creating AJI and see the preformance? Cheers, Raja
25027 Nov 2013 @ 11:15 PSTThird Party SoftwareReplyWhich is a better BI tool? SAS or Qlickview/QlikTech. Any suggestions?Hi, It is a very generic question. Qlikview is in-memory BI tool.It depends on many factors, like cost, TCO, resources and what you want.  SAS has long history. Qlikview is new. Se...
24927 Nov 2013 @ 08:52 PSTDatabaseReplyError 5505 Column data types cannot be specified with a WITH [NO] DATA clause.Hi, Are you using the column correctly? Please check it. Cheers, Raja
24827 Nov 2013 @ 08:44 PSTDatabaseReplyCount the number of words in a phrase using Teradata SQLHi Sreechandn, If you are in TD Version 14, then you can make use of  regex_replace function along with length function. Another easier way, I always follow is use a procedure, because I can...
24727 Nov 2013 @ 08:14 PSTUDAReplyCancel Rollback on a table with referential integrityHi, I used to kill jobs, either from Linux, unix prod as a last resort. It's usually fine. Of course, with other DBs, the index becomes unusabe or invalid most of the time. Thank you very muc...

Pages