![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() 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 : Here ,BTEQ is mainly suitable for Small tables and we can perform any arithmetic operations in a query like computations using Funtions and INSERT WITH SELECT combinations all we can do that. ... 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 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||