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

1090

Explain the most common data types used in teradata?

1125

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

1188

What is meant by a Least Cost Plan?

1106

Highlight the advantages of PPI(Partition Primary Index).

1127

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1081

what is object level locking ? where do appear this type of locking ?

3544

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1159

Highlight a few of the advantages that ETL tools have over Teradata.

1137

if collect stats but it show low confidence why?

1749

Explain fallback in teradata?

1105

Which is more efficient group by or distinct to find duplicates?

1130

What are the steps to create a data model?

1107

What are default access rights in teradata? What explicit right can be given to a user?

1145

How you will check the version of teradata?

1223