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 |
What is bteq script in teradata?
Why do Hash joins usually perform better than Merge Joins?
What are the functions involved in shared information architecture?
Highlight the need for Performance Tuning.
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
What is the difference between fastload and multiload?
What are the components used in smp and massively parallel processing (mpp) machines?
What is the primary index in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain some differences between mpp and smp?
how do you manage the production space. what are the proactive methods you can take ?
What are the different table types that are supported by teradata?