22 | 17 Sep 2015 @ 10:54 PDT | Database | Reply | Data Block size | The maximum data block size for all systems is 130,560 bytes (255 sectors). per SQL Data Definition Language Syntax and Examples Release 14.0 B035-1144-111A page 53
|
21 | 17 Apr 2015 @ 12:16 PDT | Database | Reply | Creating and populating a parameterized table inside a stored procedure | create the table and then compile the procedure
|
20 | 17 Apr 2015 @ 12:04 PDT | Database | Topic | transforming data | I have data in below format
product seqnum DATE
a 1 1987-06-24
a 2 1987-06-24
a 3 2014-11-20
a 4 2015-03-25
and i am looking to convert into this
product seqnum startd... |
19 | 07 Jan 2015 @ 10:55 PST | Private Forum |
18 | 07 Jan 2015 @ 08:43 PST | Private Forum |
17 | 05 Nov 2013 @ 08:22 PST | Tools | Reply | TPT: system variables with result count | Cant We use the exit routine which has this meta data such as records read and inserted
|
16 | 23 Sep 2013 @ 04:45 PDT | Database | Reply | Migrate All the Tables of SQL Server DataBase to TeraData in one go | You can uses SSIS and Teradata connector to load data .. ou might have to do some transformation to support data types
|
15 | 27 Aug 2013 @ 08:00 PDT | Viewpoint | Reply | Viewpoint and PDCR | Both Viewpoint and PDCR sseems to be collecting the same information on key system metrics CPU, Concurrency, SQL,Space, canaries. There is some difference but its going down which each increment ve... |
14 | 25 Jul 2013 @ 08:18 PDT | Private Forum |
13 | 19 Jul 2013 @ 01:33 PDT | Private Forum |
12 | 19 Jul 2013 @ 12:37 PDT | Private Forum |
11 | 17 Jul 2013 @ 06:02 PDT | Viewpoint | Reply | Viewpoint and PDCR | anybody ?
|
10 | 17 Jul 2013 @ 05:57 PDT | Database | Topic | Temporal Table | Hi,
I am looking to create temporal tables in the Warehouse, If i create temporal table with 10 columns and I only want that the temporal history to be maintained for 5 columns is that possible.&n... |
9 | 10 Jul 2013 @ 07:45 PDT | Viewpoint | Topic | Viewpoint and PDCR | Isnt there a duplication of effort in collection of performance metrics and reporting of the system by both Viewpoint and PDCR. is there any plan to integrate them into one.
|
8 | 19 Dec 2012 @ 04:07 PST | Tools | Reply | SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition | yes i did try this, i had 30-40 odd columns in the sql so wanted to check before maknig the change.
Anyways i made the change and it works.. its strange thogh there's no implicit conversion. i... |
7 | 03 Dec 2012 @ 05:17 PST | Tools | Reply | tbuild, failures of EXPORT operator on linux | Hi,
I am facing the same error and using 13.10.00.02 version. is the upgrade only resolution.
TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the... |
6 | 03 Dec 2012 @ 04:36 PST | Tools | Reply | SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition | if we change the query too 'SELECT cast(MSISDN as varchar(40)) FROM SANDBOX.CTF_REF_CHURN', will that help get rid of this error ?
|
5 | 05 Jan 2012 @ 10:41 PST | Private Forum |
4 | 30 Nov 2011 @ 10:43 PST | Tools | Reply | Fastload DateTime, Timestamp |
Thanks everone, as a workaround I used multiload and use substring to get the date.
|
3 | 30 Nov 2011 @ 01:53 PST | Tools | Reply | Fastload DateTime, Timestamp |
nybody ?
|
2 | 14 Nov 2011 @ 05:59 PST | Tools | Reply | Fastload DateTime, Timestamp |
The Data that i have in the file is ttimestamp and I want to load into the date colum..
thats what i thought this thread was about..
With regards to numeric, i just picked the... |
1 | 07 Nov 2011 @ 07:42 PST | Tools | Reply | Fastload DateTime, Timestamp |
This doesnt seem to work , is it even possible.. I have tried with both having b for blank space in the format..but still the records got rejected
data
30,2011-01-01 00:00:00
40,2011-1... |