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 is the use of teradata system software?
what is object level locking ? where do appear this type of locking ?
Define views in teradata with syntax.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the advantages of teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is primary index and secondary index?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain teradata utilities. What is multiload, fast load, tpump?
Difference between multiload and tpump?
What is the meaning of Caching in Teradata?
What is a dimension table?
What is the difference between fastload and multiload?
How to find duplicates in a table?
What's the difference between timestamp (0) and timestamp (6)?