What are the types of tables in Teradata
Answer Posted / pandit
Derived Tables: Tables created for subquery. these are
Query specific. Once the query is over they are dropped.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the various etl tools in the market?
Explain the advantages of partitioned primary index in a query?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the steps to create a data model?
What is the command in bteq to check for session settings ?
What is the difference between fastload and multiload? Which one is faster?
How does hashing happens in teradata?
Explain vproc in teradata?
Highlight all the modes that are present under Confidence Level.
What is the function of parser component in teradata?
What does Amp contain and what are all the operations that it performs?
What is difference between user and database in teradata?