Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23458 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
Explain the teradata primary index mechanics in detail with a diagram.
Explain parsing engine in teradata?
What is TPD?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What tools would you use for that?
What are the newly developed features of Teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is a three-tier data warehouse?
What are the different functions performed in development phase?
List out some of the primary characteristics of teradata.
Can you connect multiload from ab initio?
How many sessions of MAX is PE capable of handling at a particular time?
What are the steps to create a data model?
what is object level locking ? where do appear this type of locking ?
What is meant by a Virtual Disk?
