-
-
-
Which two can be implemented as a centrally located logical architecture?
č operational data storeč logical data mart
-
-
-
-
-
How teradata makes sure that there are no duplicate rows being inserted when its a SET 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 the whole row, and find out if duplicate.If its a duplicate it silently skips it without throwing any error.Cheers,Shilpa
-
Teradata Optimization and Performance Tuning
What is optimization and performance tuning and How does it work in practical projects. Explain with an example.
-
Set and Multi Set Tables
What are set tables and multiset tables in Teradata?Explain with an appropriate example?
-
-
SPOOL Process Error Types
How many types errors will be occur in total SPOOL process How will you connect a database server to other server?
-
Low and High Confidentiality
Explain What are Low and High Confidentiality in Explain command.
-
EXCEPT and MINUS
What is the difference between EXCEPT and MINUS operator in Teradata SQL?
-
What is a common data source for the central enterprise data warehouse?
Operational data stores
-
-
-
What is explain in teradata?
What is explain and how does it work?
-
Which two statements are true about a foreign key?
Each Foreign Key must exist as a Primary Key.Foreign Keys can change values over time.
-
Teradata versions
How many version is there in Teradata? please give me detail information for version ? Version Name and Particular date ?
Teradata Interview Questions
Ans