what is referential constraints?how do you implement RI in
teradata?
Answers were Sorted based on User's Feedback
Answer / tdguy
Referential Integrity is based upon how Primary and Foreign
keys are defined. Because of this rule, a referenced column
must be a Primary Key or must be Unique and Not Null. Using
create or alter statement, FK can be created.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
How to identify ppi columns?
What are the uses of client software involved in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
what are the roles and responsibilities of teradata DBA ?
which join mostly use in realtime?
What are default access rights in teradata?
What happens in a conflict? How do you handle that?
What is meant by a dispatcher?
Explain the term 'columns' related to relational database management system?
Explain the types of join supports by teradata?
If a Node is busy what are the steps you can take to avoid ?