in teradata level primary in table level allows duplicates why?
Define views in teradata with general syntax.
How do you define Teradata?
What is the maximum number of dml can be coded in a multiload script?
Why Fload doesn’t support multiset table?
why should we go Teradata over Oracle,what is the main differences?
What are the different methods ot loading a dimension table? A fact table etc?
How would you load a very large file in teradata in general?
Highlight the differences between Primary Key and Primary Index.
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What are aggregate tables? How do you design them using teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
If table have access lock.In the same table write lock is posible or not?