Derived Tables: Tables created for subquery. these are Query specific. On

What are the types of tables in Teradata

Question Posted / pandit

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

Please Help Members By Posting Answers For Below Questions

What is the maximum number of dml can be coded in a multiload script?

1106

Did you write stored procedures in teradata?

1128

What is inner join and outer join?

1104

Can we collect statistics on multiple columns?

1061

What is meant by Teradata Gateway?

1058

What are the 5 phases in a multiload utility?

1031

What is the meaning of Caching in Teradata?

1134

How to view every column and the columns contained in indexes in teradata?

1050

What are the steps involved in the process flow of the sql statement through channel attached system?

1100

Explain the term 'database' related to relational database management system?

980

What interface is used to connect to windows based applications?

1108

What is the difference between teradata and basic rdbms?

1013

Difference between multiload and tpump?

1099

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1236

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1950