What are the types of tables in Teradata
Answer Posted / rajesh kumar
update on previous answer:
1.Derived table stores the derived result from a subquery.
2.It uses only spool space, so no table definition,
permission needed.
simple query eg:
select * from (select max(sal) from emp) DT (Max_sal)
answer:
derived table(DT) has Max salary and result would be
Max_sal- here subquery result is maintained in derived table
-------
25000
3. derived table auto drops after the query ends
Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What are types of partition primary index (ppi) in teradata?
How will you solve the problem that occurs during update?
Explain and compare pros and cons of start schemas?
What are normalization, first normal form, second normal form and third normal form?
What are the various reporting tools in the market?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the main components of teradata system?
What is meant by a Least Cost Plan?
Highlight a few of the important components of Teradata?
how do you manage the production space. what are the proactive methods you can take ?
Name the five phases that come under MultiLoad Utility.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are tpump utility limitations?
What do you mean by caching in teradata?
When tpump is used instead of multiload?