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?
What tools would you use for that?
In general, how do you optimze any sql in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
How do you do backup and recovery in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
Explain and compare pros and cons of start schemas?
