Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23343 Views
- I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
RI is created using creat or alter statement. RI can be
created for a populated table also. In that case the error
is moved to a error table. After clearing out the errors,
the rows can be inserted in to child or parent table.
In teradata, Soft RI is one feature, where the checking is
not done for every update or insert. It is created by using
no check option while using create statement.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What are the components used in smp and massively parallel processing (mpp) machines?
What is the syntax for case when statement?
What do you mean by teradata intellicloud?
What is collect statistics?
Why are oltp database designs not generally a good idea for a data warehouse?
What is a node in teradata? Explain
How is the teradata different from oracle?
What are the scenarios in which full table scans occurs?
Difference between inner join and outer join?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is inner join and outer join?
What is meant by Teradata Gateway?
Name the five phases that come under MultiLoad Utility.
What are some commonly used bteq scripts?
What is dimensional modeling?
