 Related Questions Latest Answer : Hi there Teradata utilities are :1)Mloads2)Fast Export3)BTEQ4)TPump5).fast load ... Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong. Read Answers (1) | Asked by : Raj Latest Answer : There are 12 codd's rules applied to the teradata database ... Read Answers (1) | Asked by : vanshika Latest Answer : BTEQ is a variant of the core set of ANSI SQL, with proprietary 'extensions' that are specific to Teradata databases only.Similar to PL/SQL for Oracle, or T-SQL for Microsoft SQL Server, BTEQ includes the ability to perform database-vendor-specific ... After creating tables dynamically in the Teardata, where is the GRANT table option usually done ? When tables are newly created, what is the default role and what the default privileges which get assigned ? Read Answers (2) | Asked by : Abhijit Jagtap Latest Answer : V2R6 included the feature of replica in it.in which copy of data base are available on another system.meam V2R6 provide the additional data protaction as comprison to V2R5 while if data from one system has been vanishes. ... Read Answers (1) | Asked by : RAVI Teradata will redirect the new inserted row as per its PI to the target AMP (on the basis of its row hash value), and if it find same row hash value in that AMP (hash synonyms) then it start comparing Latest Answer : When the target table has UPI then the Row hash of PI column will lead to the AMP and the duplicate row is rejected with an error.In case of a NUPI defined on a SET table the duplicate row is compared on all columns and if the entire row is dups ... Global Temporary tables (GTT) -1. When they are created, its definition goes into Data Dictionary.2. When materialized data goes in temp space.3. thats why, data is active upto the session ends, and definition Latest Answer : In addition to the Shilpa's answer,If you are using volatile table,you can not put the default values on column level ( while creating table ) ... what is an optimization and performance tuning and how does it really work in practical projects. can i get any example to better understand. Latest Answer : Performance tuning and optimization of a query involves collecting statistics on join columns, avoiding cross product join, selection of appropriate primary index (to avoid skewness in storage) and using secondary index.Avoiding NUSI is advisable. ... what is explain and how does it work? Latest Answer : The EXPLAIN facility is a teradata extension that provides you with an "ENGLISH" translation of the steps choosen by the optimizer to execute an SQL statement.It may be used oin any valid teradata database with a preface called "EXPLAIN".The ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
