Interested to Buy Any Domain ? << Click Here >> for more details...
Can we take collect stats on Dervied Tables and Volitable
tables,
What is Golabal Temporary table what is the use of this
Golabal Temporary table ,When we create any kind table in
Teradata it will show in Golabal Temporary table
- 6 Answers
- 21359 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vinay sir,dwh technologies,ame
Small correction guys for the above answers:
We can collect statitics on volatile tables in TEARADATA-13.
Just try at home.
Derived tables any way we can collect.
Volatile tables life time with in the session(Data and
Structure).
Global temporary tables life time accross sessions
(definition only).
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Difference between star and snowflake schemas?
What is a level of granularity of a fact table?
What are the various indexes in teradata? How to use them?
Explain BYNET.
What are the components used in smp and massively parallel processing (mpp) machines?
Explain the types of join supports by teradata?
How will you solve the problem that occurs during update?
Explain PDE.
What is the syntax for case when statement?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain some differences between mpp and smp?
What are the different softwares used with their functions in teradata?
What happens in a conflict? How do you handle that?
Explain the new features of teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
