Covid-19 Update!!    We have enabled all courses through virtual classroom facility using Skype or Zoom.    Don't stop learning.    Enjoy Learning from Home.

30% Discount Python        30% Discount Webdesign        30% Discount SEO        30% Discount Angular8        Free SQL Class        Free Agile Workshop       Free HTML Sessions        Free Python Basics

Important Teradata Interview Questions and Answers

Teradata interview question and answers

1. How do you define Teradata? Give some of the primary characteristics of the same.

An RDMS which is applied to drive the Datamart, Datawarehouse, OLAP, OLTP, as well as DSS devices of the company is Teradata.
Some of the primary characteristics of Teradata are given below.
  • Is capable of running on Single-nodes, as well as multi-nodes.
  • Parallelism is built into the system.
  • Very much compatible with the standards of ANSI.
  • Tends to act in the same way as a server.
  • It is an Open System that basically executes for UNIX MR-RAS, Suse Linux ETC, WIN2K, etc.

    2. What are the newly developed features of Teradata?

    The features of Teradata are :
  • Automated temporal analytics
  • Extension in the compression proficiency which permit flexible compression of data about 20 times more, than the previous version.
  • Customer associated innovation like tetradata viewpoint.

    3. Highlight a few of the important components of Teradata.

    Important components of Teradata are :
  • Bynet.
  • Access Module Processor (AMP).
  • Parsing Engine (PE).
  • Virtual Disk (vDisk).
  • Virtual Storage System (VSS).

    4. Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

    The procedure by which we can run Teradata is perform completion in UNIX by the following method.
    $Sh > BTEQ < [Script Path] > [Logfile Path]
    or
    $Sh > BTEQ < [Script Path] TEE [Logfile Path]

    5. If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

    There are two ways to restart.

  • Making the old file to run – Make sure that you do not completely drop the error tables. Instead, try to rectify the errors that are present in the script or the file and then execute again.
  • Running a new file – In this process, the script is executed simply using end loading and beginning statements. This will help in removing the lock that has been put up on the target table and might also remove the given record from the fast-log table. Once this is done, you are free to run the whole script once again.

    6. Mention a few of the ETL tools that come under Teradata.

    ETL tools which are often used in Teradata are DataStage, Informatica, SSIS, etc.

    7. Highlight a few of the advantages that ETL tools have over TD.

    The advantages of ETL tools have over TD are: –
  • Multiple diverse destinations, as well as sources can be operated.
  • Debugging process is much easier with the help of ETL tools owing to full-fledged GUI support.
  • Unit of ETL tools can be `comfortably reused, and as a result, if there is an update to the main server, then all the corresponding applications connected to the server are updated automatically.
  • De-pivoting and pivoting can be easily done using ETL tools.

    8. What is the meaning of Caching in Teradata?

    Caching is considered as an added advantage of using Teradata as it basically works with the source which stays in the same order i.e. does not change on a frequent basis. At times, Cache is usually shared between applications.

    9. Give a justifiable reason why Multi-load supports NUSI instead of USI.

    The index sub-table row develops to be on the same Amp in the same way as the data row in NUSI. Hence, each Amp is operated separately and in a parallel manner.

    10. Expand PDE.

    Parallel Data Extension is the abbreviation for PDE.

    11. What is TPD?

    TPD stands for Trusted Parallel Database and it works under PDE even it is created in Teradata. This is the reason why Teradata is usually referred to as Trusted Parallel or Pure Parallel database.

    12. What is Channel Driver?

    A channel driver is software that acts as a medium of circulation between PEs and all the applications that are running on channels.

    13. What is Teradata Gateway?

    It acts as a medium of circulation between the Parse Engine and applications that are connected to network clients.

    14. What is a dispatcher?

    Dispatcher takes a whole collection of requests and then keeps them stored in a queue. The same queue is being kept throughout the process in order to deliver multiple sets of responses.

    15. What is the particular designated level at which a LOCK is liable to be applied in Teradata?

  • Table Level – All the rows that are available inside a table will undeniably be locked.
  • Database Level Lock – All the objects that are available inside the database will be locked
  • Row Hash Level Lock – Only those rows will be locked which are proportionate to the particular row.
    • Related Courses

    Learning Solutions

    Why TIB ACADEMY is No.1 in Bangalore?

  • All technologies under “ONE ROOF”
  • Pool of experts as “TRAINERS”
  • Tailor made syllabus
  • One-on-One attention to students
  • Flexible training modes
  • Mini POC’s for every module
  • Job oriented assistance
  • Affordable course fees
  • Flexible schedules
  • Flexible payment terms
  • Money back guarantee
  • Exclusive Seasonal discounts and offers

    • For more Interview Q & A

    Amazon Web Services

    aws-interview-questions-and-answers

    Bigdata

    big-data-interview-questions-and-answers

    Salesforce Developer

    salesforce-interview-questions-and-answers

    Salesforce Admin

    salesforce-admin-interview-questions-and-answers

    Teradata

    teradata-interview-questions-and-answers

    Quick Contact


    Opening Hours

    • Mon - Fri :
      7.00 am - 9.00 pm
    • Sat :
      8.00 am - 10.00 pm
    • Sun :
      7.00 am - 9.00 pm

    Address - TIB Academy

    Second Floor and Third Floor,
    5/3, Varthur Road, Kundalahalli Gate,
    Behind Kundalahalli Stop    , Bangalore,
    Karnataka 560066, India