How you will check the version of teradata?

1166

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1078

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1024

What are the various indexes in teradata? Why are they preferred?

1005

Highlight the advantages of PPI(Partition Primary Index).

1075

What are the steps to create a data model?

1053

Why are oltp database designs not generally a good idea for a data warehouse?

1056

Explain the term 'primary key' related to relational database management system?

1034

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1152

What is spool space? Why do you get spool space errors?

1019

Highlight all the modes that are present under Confidence Level.

971

What is the difference between fastload and multiload?

1380

What is the purpose of joins in teradata and what are the available join types?

1085

What are the different softwares used with their functions in teradata?

1015

What is the purpose of joins in teradata?

1187