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
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Which is more efficient group by or distinct to find duplicates?
What's the difference between timestamp (0) and timestamp (6)?
How many tables can you join in v2r5?
What are differences between teradata and ansi session modes in teradata?
What is meant by a Virtual Disk?
What are the multiload utility limitations?
Why does varchar occupy 2 extra bytes?
Explain and compare pros and cons of start schemas?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How can bottlenecks be identified?
What happens when a node suffers a downfall?
How many sessions of MAX is PE capable of handling at a particular time?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the use of stored procedures in teradata?