SriniTera

#Top Teradata Interview Questions and Answers: The teradata interview questions of second set. What is the usage of Fallback? A) When a table is fallback protected the rows are duplicated on other AMPs. Fallback is similar to mirroring, but different. The similarities is that both provide a duplicate copy, but the difference is that Fallback places copies of its rows on multiple AMPs so if a failure occurs Teradata can use the parallelism to help the failed AMP. Teradata+Interview +Questions-Part-1 How many primary keys we will apply on a table? A) Only one How does rows store in Teradata? A) It spreads the rows across all AMPs Tell me the types of Indexes? A) PI - Primary index NoPI-No primary index UPI-Unique primary index NUPI-Non unique primary index USI-Unique secondary index NUSI-Non unique secondary index Difference between UPI and NUPI and the situation where exactly? We will use these? Teradata indexes The role of SI in teradata and...

#Two most popular kinds of Teradata Utilities that must read: Block level utilities: FastLoad performs Inserts into empty Teradata tables in 64K blocks. MultiLoad loads to populated Teradata tables in 64K blocks. FastExport – Exports data off of Teradata at the 64K block level. Row level utilities: BTEQ – The first Teradata query tool. It imports and exports data and should be used when < 500,000 rows. BTEQ is an excellent report writer.    TPump loads into Empty or Populated Tables and is a lot like MultiLoad except TPump does all of the work at the row level and NOT the block level. It is called TPump because you can turn up or down the pump to increase or decrease the load quantities. How data is stored in Teradata: Teradata stores data in tables much like an Excel spreadsheet.  Each row has many columns. The difference is how Teradata processes the data.  The rows are not stored together like an Excel spreadsheet. Each row is ...