1) What is meant by a Least Cost Plan?
A Least Cost Plan basically executes in less time across the shortest path.
2. What is meant by a Channel Driver?
A channel driver is software that acts as a medium of communication between PEs and all the applications that are running on channels which are attached to the clients.
3. Highlight a few of the important components of Teradata?
Some of the important components of Teradata are:
All you have to do is perform execution in UNIX in the way as mentioned below.
$Sh > BTEQ < [Script Path] > [Logfile Path]
or
$Sh > BTEQ < [Script Path] TEE [Logfile Path]
5. In Teradata, how do we Generate Sequence?
In Teradata, we Generate Sequence by making use of Identity Column
6. During the Display time, how is the sequence generated by Teradata?
All you have to do is use CSUM.
7. A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
The most suggestible utility here has to be Tpump. By making use of packet size decreasing or increasing, the traffic can be easily handled.
8. If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
There are basically two ways of restarting in this case.
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.
9. Mention a few of the ETL tools that come under Teradata?
Some of the ETL tools which are commonly used in Teradata are DataStage, Informatica, SSIS, etc.
10. Highlight a few of the advantages that ETL tools have over TD?
Some of the advantages that ETL tools have over TD are: –
Multiple heterogeneous 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.
Components of ETL tools can be easily 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.
Tags: Teradata Interview Questions and Answers At Microsoft, Microsoft, Interview Questions and Answers At Microsoft, Teradata, Teradata Interview Questions, Teradata QA, Teradata Interview Questions and Answers, Teradata Tutorial, Teradata books, Teradata Interview Questions pdf, Teradata experienced QA, interview questions, Teradata interview questions for experienced, Teradata interview questions for developers,Teradata interview questions for freshers,Teradata interview questions senior level, Teradata Certification Questions, Basic Teradata interview questions, Teradata interview questions 2 3 4 5 6 years experienced, Teradata Real time interview questions, Teradata Interview Questions and Answers At Microsoft 2015, Latest Teradata Questions At Microsoft Interview.
A Least Cost Plan basically executes in less time across the shortest path.
2. What is meant by a Channel Driver?
A channel driver is software that acts as a medium of communication between PEs and all the applications that are running on channels which are attached to the clients.
3. Highlight a few of the important components of Teradata?
Some of the important components of Teradata are:- Bynet
- Access Module Processor (AMP)
- Parsing Engine (PE)
- Virtual Disk (vDisk)
- Virtual Storage System (VSS)
All you have to do is perform execution in UNIX in the way as mentioned below.
$Sh > BTEQ < [Script Path] > [Logfile Path]
or
$Sh > BTEQ < [Script Path] TEE [Logfile Path]
5. In Teradata, how do we Generate Sequence?
In Teradata, we Generate Sequence by making use of Identity Column
6. During the Display time, how is the sequence generated by Teradata?
All you have to do is use CSUM.
7. A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
The most suggestible utility here has to be Tpump. By making use of packet size decreasing or increasing, the traffic can be easily handled.
8. If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
There are basically two ways of restarting in this case.
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.
9. Mention a few of the ETL tools that come under Teradata?
Some of the ETL tools which are commonly used in Teradata are DataStage, Informatica, SSIS, etc.
10. Highlight a few of the advantages that ETL tools have over TD?
Some of the advantages that ETL tools have over TD are: –
Multiple heterogeneous 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.
Components of ETL tools can be easily 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.