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
- 21330 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
Which is faster fastload or multiload?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is teradata?
In Teradata, what is the significance of UPSERT command?
What is a node in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Why do you get spool space errors? How do trouble-shoot them?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What do you mean by ttu in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is a level of granularity of a fact table?
What type of indexing mechanism do we need to use for a typical data warehouse?
Define views in teradata with syntax.
What is basic teradata query language?
