18 | 11 Feb 2016 @ 11:22 PST | Database | Topic | Optimal Process to load data from SQLserver to Teradata | We have a a number of processes where in we transfer the data from SQL server to TD. We extract he data as files & then dump it using Fastload. Just wanted to know is there any other process we... |
17 | 20 Jul 2014 @ 10:59 PDT | Database | Reply | Impact of using a compressed column in any join or predicate clause in a query | Thanks all for clearing the doubt, henceforth i will keep that in mind :)
|
16 | 18 Jul 2014 @ 07:29 PDT | Database | Topic | Impact of using a compressed column in any join or predicate clause in a query | Hi All,
I would like to know If there would be any impact of I/O if we perform any join operations or filter operations on the compressed column considering compression property is majorly a space... |
15 | 12 Jun 2014 @ 06:09 PDT | Database | Reply | Order Of columns in PI for multilevel Partitioned Table | Hi,
Sorry for a late reply. I do think the same ways. Thanks for conforming :)
|
14 | 04 Jun 2014 @ 08:24 PDT | Database | Topic | Order Of columns in PI for multilevel Partitioned Table | Hi All,
I am aware that order of columns in defined PI doesn't matter.
But if we have multilevel Partition defined on the table and we are including the partitioning columns as a part of PI, ... |
13 | 10 Feb 2014 @ 02:22 PST | Database | Reply | Generating Surrogate Key Using ROWNUM | Adeel,
Its loaded from a single source(TD source table).
I tried with "SUM(1) OVER(ROWS UNBOUNDED PRECEDING).." method as mentioned above, but did not find much difference.
|
12 | 03 Feb 2014 @ 01:08 PST | Database | Reply | Generating Surrogate Key Using ROWNUM | Adeel,
Estimated Row count = 200 million
Dieter,
I guess its the calculation of the ROW_NUMBER() part because I tried without the max part but of no help.
The query is something like this:... |
11 | 31 Jan 2014 @ 04:59 PST | Database | Topic | Generating Surrogate Key Using ROWNUM | Hi All,
Greetings !
I have a requirement where I have to generate a surrogate ID for every row in the FACT table. Previously we used to use ROW_NUMBER() for the same. But the data volume has gone... |
10 | 24 Mar 2013 @ 08:52 PDT | Tools | Topic | Restarting Fastload if we have error with the source data file | Hi,
I had encountered today a failure with fastload. There was some issue with the source file for which the fastload got paused. I corrected the data and restarted the run, but it didnt succeed.
... |
9 | 27 Aug 2012 @ 08:04 PDT | Database | Topic | Need help understanding MLPPI ? |
Hi All,
I am facing trouble understanding the terms contigous partition and repositioning when i am reading material related to MLPPI. Could anyone please do me a favour understanding these... |
8 | 13 Aug 2012 @ 08:24 PDT | Database | Reply | Max value for datatype column. |
Thanks a ton, the suggest approach got me my result !!
|
7 | 13 Aug 2012 @ 06:18 PDT | Database | Topic | Max value for datatype column. |
Can we write a SQl to determine the max value of a datatype ?
For ex: if we have a column emp_id as INTEGER, the SQL would have emp_id as input and the result would be the max value for inte... |
6 | 25 Mar 2012 @ 01:36 PDT | Database | Reply | Performance question |
You should try using the implicit datatype conversion where ever possible, if not possile you should make use of cast function.
|
5 | 21 Jan 2012 @ 12:42 PST | Database | Reply | DDL review |
I am supposing your table is a final table.
Looking at the datamodel can give you a better idea of the indexes u need to create for the table.The creation of partition column always is not n... |
4 | 15 Jan 2012 @ 02:31 PST | Database | Reply | Querry error...... |
You can debug it from the SQL Assistant as it specifies the error and line number.
Yes..there are specific error numbers for a defined errors..you can find a teradata error document where yo... |
3 | 06 Dec 2011 @ 06:16 PST | Database | Topic | Altering SET to MULTISET |
Hi,
Is there is a way to alter a set table to multiset apart from drop re-create table..?
|
2 | 07 Sep 2011 @ 01:52 PDT | Database | Reply | Timestamp Datatype |
Thanks for helping out.
|
1 | 06 Sep 2011 @ 05:22 PDT | Database | Topic | Timestamp Datatype |
Hi All,
Can you please explain the concept for timestamp(0),timestamp(1) ....timestamp(6)..?
Thanks in advance for the help.
|