Highlight the points of differences between the database and user in Teradata.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
The transaction exceeded the maximum number of rowhash locks allowed
How do you define Teradata?
How a Referential integrity is handled in Teradata?
Describe primary index in teradata?
What is a dimension table?
Explain and compare pros and cons of snow flake schemas?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
what is the structure of UV table in MLOAD?
If a Node is busy what are the steps you can take to avoid ?
what is referential constraints?how do you implement RI in teradata?