teradata
Teradata macro parameter as time interval
This is almost the same problem as Informix defining an INTERVAL with a parameter but is in Teradata.[详细]
2023-02-08 21:35 分类:问答What is the difference between a banyan network and a folded banyan network?
What is the difference between a folded banyan and a regular banyan network. Teradata replication is apparently based on a folded banyan design, but many of the google top 开发者_开发百科ranked result[详细]
2023-02-07 23:36 分类:问答difference between minus and except in Teradata
what 开发者_如何学Cis the difference between minus and except in teradata?They are equivalent, the difference being that except is ANSI compliant.Here is a good link for you:[详细]
2023-02-02 09:25 分类:问答How can I perform fastload for a file which has only one column and 'n' rows?
I have done fastload for table which has more than one column (I did this with vartext format with , as delimiter).[详细]
2023-01-28 00:27 分类:问答Consolidate 2 tables via a mapping table - Full Joins?
Briefly described, I have 2 tables that have \'equivalent\' rows in each other. The equivalencies are maintained in a 3rd Mapping table (which maps ID A to ID B). In a view I want to create a consolid[详细]
2023-01-27 08:46 分类:问答.Net Data Access integration with Teradata 12.0
I have am working on a .net application that integrates with a Teradata database version 12. Currently, we are using Odbc at the DAL to interface with the database.[详细]
2023-01-20 22:19 分类:问答Teradata - Invalid Date supplied for FIELD
I\'m trying to query a table that has a varchar(100) \"VALUE\" column. This column can hold anything from a letter, a number or, in this case, a date.[详细]
2023-01-18 03:54 分类:问答Teradata Optimizer Equal vs Like in SQL
I am currently trying to optimize some bobj reports where our backend is Teradata. The Teradata optimizer seems very finicky and I was wondering if anyone has come up with a solution or a workaround t[详细]
2023-01-16 07:38 分类:问答How to filter teradata help table
I\'d li开发者_运维问答ke to create a table out of the dataset generated by teradata\'s \"help table\" function so i can add some more information about the table, and be able to filter the rows by con[详细]
2023-01-15 20:06 分类:问答Parse/deconstruct SQL with VBA-Access
Does anyone know of a way to deconstruct a SQL statement (take a select SQL statement, extract columns from each SELECT, tables from each FOR and each JOIN, and filtering criteria from each WHERE. I c[详细]
2023-01-14 03:20 分类:问答