What are default access rights in teradata? What explicit right can be given to a user?
What are the available join types 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 ?
What is the purpose of upsert command?
What tools would you use for that?
In BTEQ, how are the session-mode parameters being set?
How will you solve the problem that occurs during update?
Define views in teradata with syntax.
What do you mean by parsing?
What is a level of granularity of a fact table?
What are types of partition primary index (ppi) in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain teradata vs. Redshift?
What is the difference between fastload and multiload?
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?