What is the Maximum number of volatile tables that can be
created?
- 4 Answers
- 8724 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / tdguy
In TD14.0, 1000 volatile tables can be created in a session.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Highlight the points of differences between the database and user in Teradata.
How will you solve the problem that occurs during update?
What does Amp contain and what are all the operations that it performs?
If RDBMS is halted what will you do ?
How do you see a ddl for an existing table?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the purpose of joins in teradata?
Comment whether bottleneck is an error or not.
Explain and compare pros and cons of start schemas?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain how spool space is used.
What is a level of granularity of a fact table?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is inner join and outer join?
