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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How do you set the session mode parameters in bteq?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
what are the day to day activities of teradata DBA ?
Highlight a few of the advantages that ETL tools have over Teradata.
How do you define Teradata?
What are the joins in teradata?
What are normalization, first normal form, second normal form and third normal form?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What do high confidence, low confidence and no confidence mean in explain plan?
Highlight the need for Performance Tuning.
What is the maximum number of dml can be coded in a multiload script?
What interface is used to connect to windows based applications?
Which is more efficient group by or distinct to find duplicates?