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
What are the frequently used data types in teradata?
What is the syntax for case when statement?
What is a three-tier data warehouse?
Explain the new features of teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
if collect stats but it show low confidence why?
Different phases of multiload?
Describe primary index in teradata?
What is spool space?
What are some commonly used bteq scripts?
What is a clique?
What are the uses of bynets in multi-node systems?
Explain teradata architecture in detail with a diagram.
How is MLOAD Teradata Server restarted after execution?
What is a dimension table?