Scribd Logo
Upload

Welcome to Scribd!

  • 409 views

    Teradata Interview Questions

    Uploaded by

    Farooq Bmd
    This document contains 22 interview questions related to Teradata concepts and technologies, including: 1. The differences between Mload, Fload, and error tables. 2. The differences in performance between Multiload and Fastload. 3. What explain is in Teradata and how indexing improves query performance. 4. How many of Codd's rules for relational databases Teradata satisfies and how SDLC may change when using Teradata instead of Oracle.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Teradata Interview Questions

    Uploaded by

    Farooq Bmd
    409 views2 pages
    This document contains 22 interview questions related to Teradata concepts and technologies, including: 1. The differences between Mload, Fload, and error tables. 2. The differences in performance between Multiload and Fastload. 3. What explain is in Teradata and how indexing improves query performance. 4. How many of Codd's rules for relational databases Teradata satisfies and how SDLC may change when using Teradata instead of Oracle.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains 22 interview questions related to Teradata concepts and technologies, including: 1. The differences between Mload, Fload, and error tables. 2. The differences in performance between Multiload and Fastload. 3. What explain is in Teradata and how indexing improves query performance. 4. How many of Codd's rules for relational databases Teradata satisfies and how SDLC may change when using Teradata instead of Oracle.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    409 views2 pages

    Teradata Interview Questions

    Uploaded by

    Farooq Bmd
    This document contains 22 interview questions related to Teradata concepts and technologies, including: 1. The differences between Mload, Fload, and error tables. 2. The differences in performance between Multiload and Fastload. 3. What explain is in Teradata and how indexing improves query performance. 4. How many of Codd's rules for relational databases Teradata satisfies and how SDLC may change when using Teradata instead of Oracle.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Teradata Interview Questions 1.Fload, Mload and error tables 2.

    What is the difference between Multiload & Fastload interms of Performance? 3. what is explain in teradata? 4. How many codd's rules are satisfied by teradata database? 5. Teradata performance tuning and optimization 6. What is the difference between Global temporary tables and Volatile temporary tables? 7. How teradata makes sure that there are no duplicate rows being inserted when its a SET table? 8. What are the enhanced features in Teradata V2R5 and V2R6? 9. What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP ? 10. In which phase of the Active Data Warehouse evolution do you use data to determine what will happen? 11. What are two examples of an OLTP environment? 12. 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 ? 13. what is basic teradata query language? 14. 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) 15. How does indexing improve query performance? 16. Does SDLC changes when you use Teradata instead of Oracle? 17. How can we build data marts from FSLDM. is there any standard approach for this? Is FSLDM supports place holder for aggregated data? 18. Which two can be implemented as a centrally located logical architecture? 19. Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong. 20. Which two statements are true about a foreign key?

    21. What is the difference between start schma and Fsldm? 22. What is a common data source for the central enterprise data warehouse?

    You might also like