271 | 02 Dec 2013 @ 01:54 PST | General | Reply | Scheduling a job in DBQL | Hi 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 &... |
270 | 02 Dec 2013 @ 01:31 PST | Database | Reply | Selecting a column based on DATE along with GROUP BY | Hi 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... |
269 | 02 Dec 2013 @ 12:48 PST | Database | Reply | Loops without using procedures | Hi,
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.... |
268 | 01 Dec 2013 @ 11:58 PST | General | Reply | Scheduling a job in DBQL | Hi 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... |
267 | 01 Dec 2013 @ 11:15 PST | Extensibility | Reply | Teradata Integration with Salesforce | Hi 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
|
266 | 01 Dec 2013 @ 10:52 PST | Extensibility | Reply | Call 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... |
265 | 01 Dec 2013 @ 09:54 PST | Analytics | Reply | Impact 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... |
264 | 01 Dec 2013 @ 08:58 PST | Data Modeling | Reply | Nemo Q | Hi,
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
|
263 | 01 Dec 2013 @ 08:26 PST | Data Modeling | Reply | PPI VS NPPI | You are welcome. Yes it is Column-Partitioned Tables, and Column-Partitioned Join Indexes.
Cheers,
Raja
|
262 | 01 Dec 2013 @ 06:17 PST | Third Party Software | Topic | SAP DS, Teradata utility model, geospatial loading to geolocator entity | Hi,
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... |
261 | 01 Dec 2013 @ 05:45 PST | Connectivity | Reply | LDAP Authorization and Simple Binds | Hi,
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... |
260 | 01 Dec 2013 @ 05:01 PST | Data Modeling | Reply | PPI VS NPPI | We have NoPI tables. Also we can have table or join index of column partitioned table that can have no Primary index.
Cheers,
Raja
|
259 | 29 Nov 2013 @ 09:24 PST | General | Reply | MVC Tool | Hi,
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... |
258 | 29 Nov 2013 @ 08:33 PST | UDA | Reply | Hot Standby Nodes | Hi Todd,
Thank you very much. I think each HSN is attached to each clique.
Thanks and regards,
Raja
|
257 | 29 Nov 2013 @ 08:28 PST | UDA | Reply | Appliance 2690 | Hi Todd,
Thank you very much.
Regards,
Raja
|
256 | 29 Nov 2013 @ 08:22 PST | UDA | Reply | Relay Services Gateway | Hi Todd,
Thank you for your time. I think it is available on all platforms.
Thanks and regards,
Raja
|
255 | 29 Nov 2013 @ 04:40 PST | General | Topic | Teradata seminars and events | Hi,
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... |
254 | 28 Nov 2013 @ 11:31 PST | Database | Reply | Re-writing a query interms of performance | Hi,
I think you need to revisit on PI (NUPI) selection , suiting the business requirement.
Do you really need partition day wise?
Cheers,
Raja
|
253 | 28 Nov 2013 @ 07:56 PST | Third Party Software | Reply | BO Universe and TD Macros | Hi,
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... |
252 | 28 Nov 2013 @ 06:43 PST | Database | Reply | Count the number of words in a phrase using Teradata SQL | Hi 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(... |
251 | 27 Nov 2013 @ 11:40 PST | Database | Reply | Re-writing a query interms of performance | Hi,
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
|
250 | 27 Nov 2013 @ 11:15 PST | Third Party Software | Reply | Which 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... |
249 | 27 Nov 2013 @ 08:52 PST | Database | Reply | Error 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
|
248 | 27 Nov 2013 @ 08:44 PST | Database | Reply | Count the number of words in a phrase using Teradata SQL | Hi 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... |
247 | 27 Nov 2013 @ 08:14 PST | UDA | Reply | Cancel Rollback on a table with referential integrity | Hi,
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... |