What is log table? What is the use of log table?
Latest Answer: The Error Table contains information concerning: - Data conversion errors, Constraint violations and other error conditions:Contains rows which failed to be manupulated due to constraint violations or Transalation errorCaptures rows that contains ...
What is optimization and performance tuning and How does it work in practical projects. Explain with an example.
Latest Answer: Optimization is the technique of selecting the least expensive plan (fastest plan) for the query to fetch results. Optimization is directly proportional to the availibility of --1. CPU resources 2. Systems resources - amps, PEs etc.=============================================================Teradata ...
How many types errors will be occur in total SPOOL process How will you connect a database server to other server?
Latest Answer: We can connect from one server to another server in UNIX using the commandssh or FTP or SUssh -Â ssh user_id@server_name ...
What are set tables and multiset tables in Teradata?Explain with an appropriate example?
Latest Answer: Set tables doesnt accept exact duplicate records to be inserted in the table. whereas multiset do. ...
There are 2 tables, table A with 10 million records, table B has 100 million records, now we are joining both tables, when we seen Explain Plan the plan showing TD will took the table A and it will redistributes
Latest Answer: Teradata is smart enough to decide when to redistribute and when to copy....It compares the tables. Are they comparable? or one is big as compared to the other?Based on simple logic it decides whether to distribute the smaller table on all the AMPs or ...
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: Ideally, there are 2 error tables in Fload. These table contains the details about the data parcel from source to the target table. We can view the data in error table.It has below detailsErrorCode, ErrorFieldName, and DataParcel ...
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
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 ) ...
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 ...
View page [1] 2 3 Next >>
Go Top
