219 | 26 Nov 2013 @ 08:49 PST | Database | Reply | required to get the records for last 6 months | I just needed one value just to check the date format :)
You can follow peters solution, if it is not working please let me know.
|
218 | 26 Nov 2013 @ 03:50 PST | Database | Reply | required to get the records for last 6 months | Yes, it makes sense, can you execute the following query and paste the some date values here,
Select order_date from sales;
|
217 | 26 Nov 2013 @ 01:17 PST | Database | Reply | required to get the records for last 6 months | If you need me to produce a working query, I would need the structure of bothe the tables and some sample data to work on.
|
216 | 26 Nov 2013 @ 01:17 PST | Database | Reply | required to get the records for last 6 months | Yes I am getting you, but what I want to take a look at the date format in your order_date column.
If this condition is not working then we might need to change the date_order format to subt... |
215 | 26 Nov 2013 @ 01:00 PST | Database | Reply | required to get the records for last 6 months | oops! Whats the data in your order_date column?
Can you please paste 2-3 values from order_date?
|
214 | 26 Nov 2013 @ 12:13 PST | Tools | Reply | How to split a Data Export by row value? | I think then it would be good for you to use stored procedure, write a stored procedure to loop through a range you want to process, pass parameters of date or CustomerID.
Stored procedure g... |
213 | 25 Nov 2013 @ 11:44 PST | Database | Reply | required to get the records for last 6 months | Hi peiter,
you can add order_date - INTERVAL '6' MONTH in the where clause.
Further you can partition this table to gain performance.
|
212 | 25 Nov 2013 @ 09:33 PST | Tools | Reply | How to split a Data Export by row value? | Hi,
You can split your export data by using a variable in WHERE condition. e.g. you can put this select statement in a macro and then calll the macro, and pass the value as paramter for where clau... |
211 | 25 Nov 2013 @ 09:28 PST | Teradata Applications | Reply | How to Change the datatype of an existing Column Of an existing Table. | Hi,
You can consult the following two topics for this problem:
http://forums.teradata.com/forum/database/how-to-modify-datatype-of-a-column-using-alter-table-command
http://forums.teradata.com/f... |
210 | 25 Nov 2013 @ 09:18 PST | Database | Reply | Any good training institude to learn teradata | Hi,
In which area?
|
209 | 24 Nov 2013 @ 11:54 PST | Database | Reply | Automate my Teradata queries | You can read the following blog to have a basic idea of Bteq
http://www.teradatahelp.com/2010/09/introduction-to-teradata-utilities-bteq_02.html
|
208 | 24 Nov 2013 @ 11:50 PST | Database | Reply | Automate my Teradata queries | Hi Parteek,
You need to put your SQL code inside Bteq as said by Ulrich. BTEQ is a Teradata sql processing tool, if you need further information about Bteq, do let me know. if you have an idea of ... |
207 | 21 Nov 2013 @ 10:22 PST | Database | Reply | Teradata Data Types to Oracle | Hi Santanu,
The following link might help you,
http://docs.oracle.com/html/B10543_01/apa.htm
|
206 | 21 Nov 2013 @ 10:00 PST | Database | Reply | Database Performance: large Table getting redistributed causing performance problems | Hi Naga,
You do not have mentioned the 2nd table's information. If the 2nd table is small you can create a hashindex on that to avoid redistribution,
even if you have proper stats colle... |
205 | 21 Nov 2013 @ 11:15 PST | General | Reply | Collecting Stats | Fahad,
I have a few recomnedations:
Try to collect stats always, as it helps the optimizer to choose best plans for query execution.
As the column has only two possible values, you c... |
204 | 21 Nov 2013 @ 05:52 PST | General | Reply | MVC Tool | What do you mean by MVC tool? If you are talking about Teradata Multi Value Compression, then you only have to define the Compression values in the Column definition which you want to compress and ... |
203 | 20 Nov 2013 @ 03:14 PST | General | Reply | Process of Change of PI in skewd table | Hi Omar,
You can analyse the distinct values in columns, less the distinct values, more the column is a candidate for compression.
For example, Gender, country, Codes etc,
To make a ... |
202 | 19 Nov 2013 @ 06:48 PST | Database | Reply | Unable to access application tables. | I believe Tom is right, Its just a rights issue, get the Select rights and you will be able to access this info.
|
201 | 19 Nov 2013 @ 04:46 PST | Database | Reply | ROW_NUMBER() same values | If you Col1 is an index column then Teradata will generate same rowhash for 'Abc' in both the rows and still the result will be same :)
|
200 | 19 Nov 2013 @ 04:05 PST | Database | Reply | ROW_NUMBER() same values | Hi Fazol,
It is the order by clause that determines which row will get number one and which row number 2 within each partition. if there is any specific requirement to number a row with same value... |
199 | 18 Nov 2013 @ 11:12 PST | General | Reply | Process of Change of PI in skewd table | Hi Omar,
To change the PI of a table you will need to recreate the table, But before making changes, make sure to analyse the demographics of the candidate PI columns. Once you have choosen a good... |
198 | 18 Nov 2013 @ 11:06 PST | Tools | Reply | Teradata JDBC Driver User Guide for 13.10/14.0 | Hi Sanjay,
You can download the all the drivers and related sfotwares from the following:
http://downloads.teradata.com/download
|
197 | 18 Nov 2013 @ 10:06 PST | Database | Reply | How to simplify query that runs out of spool space? | Hi Vamsi,
You can fin some of the new features introduced in TD 14 at the following:
http://pk.teradata.com/News-Releases/2011/Teradata-Database--the-Smartest-Database-for-the-Smartest-Analytics/... |
196 | 18 Nov 2013 @ 10:01 PST | Database | Reply | Two Point Commit | Hi Kishore,
You can the following URL for the details about two phase commit in Teradata.
http://teradatafaqs.blogspot.com/2012/01/what-is-two-phase-commit-2pc-in.html
http://www.info.tera... |
195 | 15 Nov 2013 @ 03:40 PST | Database | Reply | Get previous column vale till it reaches another not null value | Try this:
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/Ordered_Analytical_Functions.083.010.html
|