what is referential constraints?how do you implement RI in
teradata?

Answer Posted / yuvaevergreen

Referential constraints define a relationship between two or
more attributes between two tables. RI can be implemented
between two tables using FOREIGN KEY option in create table.
FOREIGN KEY (b) REFERENCES WITH NO CHECK OPTION tb1(a));
CHECK or NO CHECK option can be used.
CHECK option - batch RI constraint.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the frequently used data types in teradata?

829


What is the syntax for case when statement?

850


What is a three-tier data warehouse?

850


Explain the new features of teradata?

823


What type of indexing mechanism do we need to use for a typical data warehouse?

861


if collect stats but it show low confidence why?

1472


Different phases of multiload?

801


Describe primary index in teradata?

799


What is spool space?

846


What are some commonly used bteq scripts?

777


What is a clique?

815


What are the uses of bynets in multi-node systems?

810


Explain teradata architecture in detail with a diagram.

871


How is MLOAD Teradata Server restarted after execution?

938


What is a dimension table?

843