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 do you design aggregate tables using teradata?
In BTEQ, how are the session-mode parameters being set?
What is a sparse index?
What do high confidence, low confidence and no confidence mean in explain plan?
What is a level of granularity of a fact table?
What is the command in bteq to check for session settings ?
What is a node in teradata? Explain
What is the function of parser component in teradata?
What are the differences between TerdataV2R5 and V12 Versions please??
Why teradata is used?
Differentiate primary key and partition key?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .