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
Explain teradata utilities. What is multiload, fast load, tpump?
What is dimensional modeling?
What is bteq script in teradata?
What do you mean by teradata intelliflex?
Define views in teradata with syntax.
How would you load a very large file in teradata in general?
What is teradata? Also, list out some of the primary characteristics of teradata.
why use references rather than pointers in the public api, particularly for arguments which are modified?
How do you verify a complicated sql?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Mention a few of the ETL tools that come under Teradata.
What do high confidence, low confidence and no confidence mean in explain plan?
What do you mean by teradata intellicloud?
Highlight all the modes that are present under Confidence Level.
How does hashing happens in teradata?