what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 6523 Views
- Wipro, I also Faced
- E-Mail Answers
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 can we analyze the locks ?
What are the various indexes in teradata?
Give some points about Teradata Viewpoint ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the primary characteristics of the Teradata.
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
Write a program to show the parser component used in teradata?
What are the available join types in teradata?
I want to write one query How to get Matched records and unmatched records in table?
can i call router is a passive transformation
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
Which Teradata concept allows more than one model generation?
Teradata 
