Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7173 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 |
What is the difference between union and union all in teradata?
what is identity column in TD?
What is Join Index in TD and How it works?
What is basic teradata query language?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Why does varchar occupy 2 extra bytes?
what is meant by Hot amp?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How to copy teradata scripts from ur remote desktop to server machine?
Different phases of multiload?
Explain fastload in teradata?
Teradata 
