#DateForumTypeThreadPost
2217 Sep 2015 @ 10:54 PDTDatabaseReplyData Block sizeThe 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
2117 Apr 2015 @ 12:16 PDTDatabaseReplyCreating and populating a parameterized table inside a stored procedurecreate the table and then compile the procedure
2017 Apr 2015 @ 12:04 PDTDatabaseTopictransforming 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...
1907 Jan 2015 @ 10:55 PSTPrivate Forum
1807 Jan 2015 @ 08:43 PSTPrivate Forum
1705 Nov 2013 @ 08:22 PSTToolsReplyTPT: system variables with result countCant We use the exit routine which has this meta data such as records read and inserted
1623 Sep 2013 @ 04:45 PDTDatabaseReplyMigrate All the Tables of SQL Server DataBase to TeraData in one goYou can uses SSIS and Teradata connector to load data .. ou might have to do some transformation to support data types
1527 Aug 2013 @ 08:00 PDTViewpointReplyViewpoint and PDCRBoth 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...
1425 Jul 2013 @ 08:18 PDTPrivate Forum
1319 Jul 2013 @ 01:33 PDTPrivate Forum
1219 Jul 2013 @ 12:37 PDTPrivate Forum
1117 Jul 2013 @ 06:02 PDTViewpointReplyViewpoint and PDCRanybody ?
1017 Jul 2013 @ 05:57 PDTDatabaseTopicTemporal TableHi, 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...
910 Jul 2013 @ 07:45 PDTViewpointTopicViewpoint and PDCRIsnt 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.
819 Dec 2012 @ 04:07 PSTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionyes 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...
703 Dec 2012 @ 05:17 PSTToolsReplytbuild, failures of EXPORT operator on linuxHi,   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...
603 Dec 2012 @ 04:36 PSTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionif we change the query too 'SELECT cast(MSISDN as varchar(40)) FROM SANDBOX.CTF_REF_CHURN', will that help get rid of this error ?
505 Jan 2012 @ 10:41 PSTPrivate Forum
430 Nov 2011 @ 10:43 PSTToolsReplyFastload DateTime, Timestamp Thanks everone, as a workaround I used multiload and use substring to get the date.  
330 Nov 2011 @ 01:53 PSTToolsReplyFastload DateTime, Timestamp nybody ?
214 Nov 2011 @ 05:59 PSTToolsReplyFastload 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...
107 Nov 2011 @ 07:42 PSTToolsReplyFastload 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...