Explain teradata utilities. What is multiload, fast load, tpump?
What are aggregate tables? How do you design them using teradata?
What is spool space? Why do you get spool space errors?
What are default access rights in teradata? What explicit right can be given to a user?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the various indexes in teradata?
Explain teradata architecture in detail with a diagram.
How would you load a very large file in teradata in general?
Why do you get spool space errors? How do trouble-shoot them?
Explain and compare pros and cons of snow flake schemas?
What are the different methods ot loading a dimension table? A fact table etc?
What are default access rights in teradata?
Explain teradata utilities?
What is spool space?
How do you create tables? Exact syntax, and create profiles, users in teradata?