Category Archive: TD Interview Questions

Mar 06

Active Database for Interview Questions

  Dear Readers, We at TeradataTech, like the idea of creating a database where we can capture all the questions asked by different technical recruiters. So that our readers can prepare well before appearing for any Teradata related interviews. This database of interview questions will come only from you all, and we encourage everyone who has …

Continue reading »

Mar 14

Interview Questions : SET 3

Question 1: Difference between MultiLoad and TPump? Answer: Tpump provides an alternative to MultiLoad for low volume batch maintenance of large databases under control of a Teradata system. Tpump updates information in real time, acquiring every bit of a data from the client system with low processor utilization. It does this through a continuous feed …

Continue reading »

Mar 09

Interview Questions : SET 2

Question 1: What is the fallback or no fallback option while creating table DDL? Answer: FALLBACK requests that a second copy of the each rows inserted into the table has a duplicate copy in another AMP in the same cluster. This way we can make the copy of the data inserted into tables. While NO …

Continue reading »

Feb 26

Interview Questions : SET 1

Question 1: Explain TPUMP (Teradata Parallel Data Pump) Utility in Teradata? Answer: TPUMP allows near real time updates from Transactional Systems into the Data Warehouse.It can perform Insert, Update and Delete operations or a combination from the same source. It can be used as an alternative to MLOAD for low volume batch maintenance of large …

Continue reading »