Explain Teradata utilities. What is MultiLoad , Fast Load, Tpump ? When do you use each of these? Why? Explain in detail. Explain Teradata Architecture in detail with diagram. What are default access rights in teradata? What explicit right can be given to a User? What happens in a conflict? How do you handle that? [...]
Teradata can perform a sync scan (synchronized full table scan) if more than one query is scanning the same table. It does this by starting the second query scan at the same data block in the table where the first query is positioned. Then the queries share the reading of data blocks going forward. When [...]
No facility to declare variables inside a Teradata macro, however you can pass values into the macro by means of input parameters. These values will then be embedded in the SQL statements that the macro contains. Teradata stored procedure supports IN, OUT and INOUT parameters, as well as the ability to declare variables within the [...]
Teradata Interview Questions Website http://teradata.techinterviewquestions.com/
2802: Duplicate row error in DatabaseName.TableName. When trying to create duplicate row in table using INSERT or UPDATE statement. SET table DatabaseName.TableName ColumnName 1 ColumnName 2 ColumnName 3 100 Ben Good 200 Ken Excellent 100 Tom Good INSERT into DatabaseName.TableName Values(200,”ken,”Excellent”) UPDATE DatabaseName.TableName set ColumnName 2 = Ben Where ColumnName 2 = Tom ; Above [...]
MDIFF – Teradata extension for the calculation of moving difference. usage: MDIFF(columnname, width, sort1 [DESC], sort2 [DESC], …) example: MDIFF (columnname1, 5, columnname2 [DESC], columnname3 [DESC], …) width: the number of previous rows to be used in computing the moving sum. The value is always a positive integer constant. The maximum is 4096.
MAVG – Teradata extension for the calculation of moving average based on a Query Width value which indicates how many preceding rows should be used for calculation usage: MAVG(columnname, width, sort1 [DESC], sort2 [DESC], …) example: MAVG(columnname1, 5, columnname2 [DESC], columnname3 [DESC], …) width: the number of previous rows to be used in computing the [...]
MSUM – Teradata extension alternative for the calculation of moving sum based on a Query Width value which indicates how many preceding rows should be used to compute sum usage: MSUM(columnname, width, sort1 [DESC], sort2 [DESC], …) example: MSUM(columnname1, 5, columnname2 [DESC], columnname3 [DESC], …) width: the number of previous rows to be used in [...]
CSUM – Teradata extension alternative for the calculation of cumulative sum usage: CSUM(columnname, sort1 [DESC], sort2 [DESC], …) example: CSUM(columnname1, columnname2 [DESC], columnname3 [DESC], … )
create global temporary targetdatabasename.tablename ( columnname 1 CHAR(01) NOT NULL , columnname 2 varCHAR(12) ) PRIMARY INDEX( columnname 1 ) on commit preserve rows ; ***Failure 2644 No more room in data base targetdatabasename. Global Temporary Tables require Perm space? Target database (for table headers) needs a minimal amount of Perm Space [...]