How many error tables are there in fload and what are their significance/use?Can we see the data of error tables?How many error tables are their in mload and what is there use?When mload job fails, can
Latest Answer: Fast load (Fload) requires two error tables that you specify in the Beging Loading Command.ERROR TABLE 1 - Contains one row for each row which failed to be loaded due to contraint violations or Transalation error.ERROR TABLE 2 - Captures rows that contains ...
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 ...
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. ...
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
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: 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. ...
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 ?
What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP ?
How many types errors will be occur in total SPOOL process and How can we connect a database server from to other server(i.e., i have to connect another server from a present server)
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. ...
View page [1] 2 3 Next >>
Go Top
