How a Referential integrity is handled in Teradata?
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 updated features of teradata?
What is TPD?
Explain teradata utilities. What is multiload, fast load, tpump?
What do you mean by tpt in teradata?
How many codd's rules are satisfied by teradata database?
What is the use of teradata system software?
What are the joins in teradata?
Difference between inner join and outer join?
What are the primary characteristics of the Teradata.
Did you write stored procedures in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
what is object level locking ? where do appear this type of locking ?
Describe the between keyword in teradata?
Explain how spool space is used.
how do you manage the production space. what are the proactive methods you can take ?