What is collect State in Teradata ? what it use and how it
works??

Answer Posted / tdguy

Stores the demographic data about the columns. Very
important for better performance.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you load a very large file in teradata in general?

557


What is real time and near real time data warehousing?

666


what are the uses of fact table and dimension table in banking project?

4095


What is the difference between union and union all in teradata?

613


What is meant by a node?

614






Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

699


Differentiate database data and data warehouse data?

581


How can bottlenecks be identified?

571


Differentiate primary key and partition key?

575


What does sleep function does in fast load?

616


How to run a query in teradata?

578


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

621


Explain fastload in teradata?

595


What are the steps involved after the disk manager passes the request?

574


Explain amp in teradata?

568