Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23676 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 can be achieved by using the teradata rdbms?
What is a dimension table?
What is meant by a Clique?
Explain and compare pros and cons of start schemas?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the various etl tools in the market?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What do you mean by teradata intellicloud?
What is logical data model?
What is the basic syntax for teradata select statement?
Can you connect multiload from ab initio?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are default access rights in teradata? What explicit right can be given to a user?
how do you manage the production space. what are the proactive methods you can take ?
