Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7056 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the parallel data extension in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is node? How many nodes and amps used in your previous project?
What are the different methods ot loading a dimension table? A fact table etc?
What is the multi-insert?
what are the uses of fact table and dimension table in banking project?
What are the available primary index types?
What do you mean by teradata intellicloud?
In the Primary Index, what is the score of AMPs that are actively involved?
Explain parsing engine in teradata?
How many codd's rules are satisfied by teradata database?
What is bteq utility in teradata?
What are the functions of a Parser?
Explain and compare pros and cons of start schemas?
What are some commonly used bteq scripts?
