what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 6254 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 |
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
which option is used to restart the fastexport script ?
Why does varchar occupy 2 extra bytes?
List out all forms of LOCKS that are available in Teradata.
In Teradata, how do we Generate Sequence?
what are the uses of fact table and dimension table in banking project?
Difference between inner join and outer join?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Explain fallback in teradata?
Can we collect statistics on table level?
how do you manage the production space. what are the proactive methods you can take ?
Highlight all the modes that are present under Confidence Level.
Teradata 
