| 31742 | 09 May 2013 @ 11:41 PDT | impressme | Database | Topic | Getting a MAX value of a column for date intersection | Hello,
I've been working on this problem for a while and need some advice. I'm not sure if what I'm trying to do is achievable without using a programming language. I can only use SQL ... |
| 31741 | 09 May 2013 @ 08:25 PDT | MFaizul_AManap | Teradata Applications | Reply | TRM 6.3.1.1 - Setting equal leads distribution in TRM 6.3 | Hi Andyling,
thanks for the reply
btw, can you elaborate more on that?
|
| 31740 | 09 May 2013 @ 02:29 PDT | gryback | Viewpoint | Reply | Password Age Alerting via Viewpoint Portlet | The Viewpoint best practices and majority of customer installs leverage the LDAP integration feature for not only managing the Viewpoint users but for password management and security aspects. Leve... |
| 31739 | 09 May 2013 @ 01:06 PDT | VandeBergB | Database | Reply | Secondary indexes | As was mentioned earlier, MLOAD supports NUSI's, but it won't support USI's...in that case you might look at other suggestions like Shelly's PPI input or drop and recreate as pre an... |
| 31738 | 09 May 2013 @ 01:04 PDT | VandeBergB | Data Modeling | Reply | Can Teradata display the Quarter value of a date? | Join your reporting date to the sys_calendar.calendar view and you can pull "quarter_of_year" from the system calendar. If you need to shift the QOY field to represent a fiscal or o... |
| 31737 | 09 May 2013 @ 12:26 PDT | macktd | Database | Topic | PPI |
Hello Experts, Please help me
I have problem with UPI, i defined UPI has customer_number,order_date.
My questions:
1)Why PPI allows UPI for partition?
2)Here, Why orde... |
| 31736 | 09 May 2013 @ 11:03 PDT | BMitchellTD | Tools | Reply | DBC.DBQLogtbl Application id meaning/definitions | The "DB-" application IDs are Ab Initio loaders, I believe.
|
| 31735 | 09 May 2013 @ 09:10 PDT | mark.lurie@ge.com | Data Modeling | Topic | Can Teradata display the Quarter value of a date? | I have a date column called reporting period date and I only want to pull data from this table where reporting period date = Q1, Q2, etc...
How would I format my reporting period date so that it r... |
| 31734 | 09 May 2013 @ 06:52 PDT | Shelley | Database | Reply | Secondary indexes | Partitioned primary indexes are great for large tables where you consistently access the data by some type or range, ie day, week, month as an example. These will reduce full table scans especially... |
| 31733 | 09 May 2013 @ 06:35 PDT | Shelley | Database | Reply | Command Help : Alter table modify column | Depending on what exactly you are trying to do, you can run an update to change values in the table. To change column format I would do an insert select from the old table into a new table with the... |
| 31732 | 09 May 2013 @ 05:18 PDT | Vga | Third Party Software | Topic | Issue in calling SP through DataStage TD connector stage | Experts, I am not sure, if I am putting this problem in the right forum. But just want to have some inputs from you:-
I have created a Stored Proedure (takes a table name as an input parameter), w... |
| 31731 | 09 May 2013 @ 04:33 PDT | barani_sachin | Database | Reply | THow to terminate teradata stored procedure..? | If u want to terminate your procedure Use "leave"
ex
-- Start of SP
LABEL_OKAY:BEGIN
If flag = 1
LEAVE LABEL_OKAY;
--End of SP
end LABEL_OKAY;
... |
| 31730 | 09 May 2013 @ 03:53 PDT | sudhirkothem | Training | Reply | Teradata Training Material available | Hi forgot to give my mails id :Sudhirkothem@gmail.com
regards,
Sudhir.k
|
| 31729 | 09 May 2013 @ 03:51 PDT | sudhirkothem | Training | Reply | Teradata Training Material available | Hi ,
I m sudhir ,New to Teradata can some one forward basic material and materials for Certifcation please .
Thanks in Advance
regards,
sudhir
|
| 31728 | 09 May 2013 @ 03:15 PDT | ashk660 | Database | Topic | THow to terminate teradata stored procedure..? | Hi,
I want to use this in Teradata Store procedure...
If flag = 1 then goto LABEL_EXIT
Else goto LABEL_OKAY
END if
flag is variable declared. I want to terminate my procedure if flag = 1...
T... |
| 31727 | 09 May 2013 @ 02:40 PDT | sachin.sebastian | Database | Reply | Minimizing Redistribution | The optimizer is doing the B JOIN C first, probably because this will reduce the number rows upfront. Check the stats on the tables to confirm if they are up to date.
|
| 31726 | 09 May 2013 @ 02:28 PDT | UM | Database | Topic | Minimizing Redistribution | I have three tables A, B and C. Table B is a bridge/ relationship table having Ids from table A and C. A and B have the same primary index. Table C has a different primary index.
I am joinin... |
| 31725 | 09 May 2013 @ 01:18 PDT | marcog82 | Tools | Topic | Load CLOB from Oracle | Hi,
I want to load a table with CLOB field from Oracle to Teradata.
I see the TPT Load but it works only if the CLOB is converted into VARCHAR.
Are there other solutions using TPT LOAD?
Thanks,... |
| 31724 | 08 May 2013 @ 11:48 PDT | Sarah_07 | Database | Topic | Avoid Error 3519 in stored procedure | Hi,
I have a created a stored procedure with many volatile tables. After calling the proc, the volatile tables will be dropped at the end of the procedure. But if i get any error while calling the... |
| 31723 | 08 May 2013 @ 09:47 PDT | cpolikowsky | Viewpoint | Topic | Password Age Alerting via Viewpoint Portlet | I don't see anything in viewpoint V14.00.00.05-b49 by default. Has anybody created their own portlet to do something like that. I would like to have a mechanism that emails an alert... |
| 31722 | 08 May 2013 @ 08:46 PDT | tomnolan | Connectivity | Reply | JDBC and JRE Supported combinations. | Our Teradata JDBC Driver supported platform matrix is available here on Developer Exchange:
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/platformMatrix.html
You a... |
| 31721 | 08 May 2013 @ 08:27 PDT | balu_td | General | Topic | Check the Header of Flat file while Mload | Every day i will receive a Flat file which i have Mload it in prod. So i have to check the Header in file and make sure it matches with old one.
File Delimited '|'
Eg : S_NO | LNAME ... |
| 31720 | 08 May 2013 @ 05:38 PDT | sekhar408 | Jobs | Reply | Immediate Req For Senior Teradata Developer @ Cary NC | Hi Jegan,
How to apply this job?
|
| 31719 | 08 May 2013 @ 01:50 PDT | johnajorgensen@yahoo.com | Database | Topic | rank variation |
Hi. Hoping you can help me with another issue. I have some data similar to that shown below, and would like to rank the states - 1-50 based on their sales totals.
... |
| 31718 | 08 May 2013 @ 11:31 PDT | deva | Database | Reply | Command Help : Alter table modify column | how can i change the data in the existing table
|
