#DateForumTypeThreadPost
37418 Jul 2011 @ 10:13 PDTDatabaseReplyTeradata to teradata replication using Golden GateTuning and sizing the replication system can be complex. You should contact your Teradata or Oracle GoldenGate support representative. This forum is not usually the best venue for getting timely ...
37317 Jul 2011 @ 11:34 PDTDatabaseReplyTeradata to teradata replication using Golden GateYes, it is possible.
37213 Jul 2011 @ 11:48 PDTGeneralReplyMaximum number of tables in a Database There is no defined limit to the number of tables in a database.
37103 Jul 2011 @ 03:08 PDTGeneralReplyNeed help in starting the TD1310_1TB - VMware PlayerYou might want to start by reading the step by step instructions that are available here: http://developer.teradata.com/database/articles/introduction-to-teradata-express-for-vmware-player
37001 Jul 2011 @ 10:30 PDTCloud ComputingReplyHow to configure/enable RSG vproc in Teradata Express 13 for VMWare player To add the RSG vproc to the configuration, use the following procedure: Step 1: Edit the vconfig.txt file (/etc/opt/teradata/tdconfig/vconfig.txt) using your preferred text editor. You just n...
36927 Jun 2011 @ 10:11 PDTGeneralReplyRestarting Mload delete job.May I just mention that all the questions that have been posted in this thead could easily have been answered by reading a bit of the MultiLoad user manual?
36820 Jun 2011 @ 10:25 PDTGeneralReplyRestarting Mload delete job.Yes.
36717 Jun 2011 @ 10:38 PDTToolsReplyTTU Connectivity with Teradata VMWare version Yes, of course. You can connect to Teradata in the VM as you would connect to Teradata on any host. You only need to set up the VMWare networking so that the IP address of the VM is known and acc...
36615 Jun 2011 @ 10:23 PDTGeneralReplyRestarting Mload delete job.It is available only for selects (with access lock). All other DML and utility operations are prohibited.
36510 Jun 2011 @ 10:00 PDTGeneralReplyANSI Merge option V2 R13The MERGE INTO statement (ANSI merge) applies a write lock on the target table.
36409 Jun 2011 @ 10:28 PDTDatabaseReplyLock qsnIf a utility lock was the blocker, the SHOWLOCKS utility will report it. You can also use the LOKDISP utility to get information about all the outstanding locks in the system. See the utilities man...
36306 Jun 2011 @ 10:53 PDTGeneralReplyRestarting Mload delete job.Once you execute RELEASE MLOAD, you lose the ability to restart the original job from any checkpoint. At that point, the delete may have been partially applied, but your table is made accessible a...
36202 Jun 2011 @ 04:35 PDTDatabaseReplyHow many bytes a unicode character set takes?In Teradata 13.10, there is a new algorithmic compression feature that is particularly useful for reducing the space utilization requirement for Unicode data. The actual space savings will vary de...
36102 Jun 2011 @ 04:07 PDTGeneralReplyRestarting Mload delete job.Absolutely, as long as you don't drop the work table or log table until the job has completed successfully. Just resubmit the job with exactly the same script. By the way, the CHECKPOINT optio...
36013 May 2011 @ 11:21 PDTToolsReplyWhere I can find the install download for Teradata Tools and Utilities (urgent!)The Teradata Express Edition for VMWare contains the regular set of Teradata utilites pre-installed in the VM image.
35913 May 2011 @ 11:13 PDTDatabaseReplyEmpty rows...EXPAND ON operates on columns of PERIOD type. An outer join using a calendar table may still be the best solution with the traditional date type. Here is a simple example: create table sales...
35812 May 2011 @ 01:55 PDTCloud ComputingReplyTeradata Express for VMware Player - Growing Pains and Version RefreshCarlos, thanks for the correction. However, it is still quite unnecessary to build a Teradata VM from scratch since the Teradata Express Edition for VMWare provides a complete pre-built VM image w...
35712 May 2011 @ 10:42 PDTDatabaseReplyQuestion on spool spaceThe maximum spool used is determined from the amount actually in use at a point in time. Some spools are often deleted after they are used in an intermediate step; then they no longer count as spo...
35611 May 2011 @ 04:04 PDTCloud ComputingReplyTeradata Express for VMware Player - Growing Pains and Version RefreshAs far as I know VMWare Player does not have the ability to create a new VM or install a guest OS. You don't need to do any of this if you have downloaded the Teradata Express Edition for VMWare, ...
35510 May 2011 @ 12:10 PDTGeneralReplyPlease help in installing Teradata ExpressA better option is to install Teradata Express for VMWare: http://developer.teradata.com/database/articles/introduction-to-teradata-express-for-vmware-player
35406 May 2011 @ 02:15 PDTDatabaseReplyUse of a Primary IndexYes, the PI is an effective access path only when exact values of all the component columns are provided in the WHERE clause. That is why the primary key is not always the best choice for primary...
35305 May 2011 @ 02:33 PDTDatabaseReplyDrop / Delete tables in bulkIf all the daily tables (and no others) are in one database, then you can use the DELETE DATABASE STATEMENT to drop all the tables after copying the tables you want keep to another database.
35204 May 2011 @ 11:14 PDTDatabaseReplyDENSE_RANKDENSE_RANK is still not available as of release 13.10.
35104 May 2011 @ 10:44 PDTDatabaseReplyAutomatic compression of NULL valuesThere is a space-time performance trade-off. One advantage of "earmarking" the space, as you put it, is that the datum location within the row can be computed with minimal cost. Computing the loc...
35002 May 2011 @ 10:15 PDTDatabaseReplyAutomatic compression of NULL valuesBy default, a null value consumes exactly the same space as a non-null value of the column type.

Pages