What is the Maximum number of volatile tables that can be
created?

Answer Posted / jyothi sinha

Up to 2000 volatile tables are allowed on a single session.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2998


How do you set the session mode parameters in bteq?

609


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

630


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

652


what are the day to day activities of teradata DBA ?

5370






Highlight a few of the advantages that ETL tools have over Teradata.

611


How do you define Teradata?

607


What are the joins in teradata?

569


What are normalization, first normal form, second normal form and third normal form?

628


How would you load a very large file in teradata in general? What utility would you use for it? Why?

599


What do high confidence, low confidence and no confidence mean in explain plan?

590


Highlight the need for Performance Tuning.

588


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

621


What interface is used to connect to windows based applications?

582


Which is more efficient group by or distinct to find duplicates?

646