Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23290 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 is teradata? What are some primary characteristics of teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
How to load specific no.of records using bteq, or fastload,or multiload
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are the joins in teradata and how many types of joins are there in teradata?
Can we collect statistics on multiple columns?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the different design perspectives used in teradata?
what are the uses of fact table and dimension table in banking project?
What is a level of granularity of a fact table?
What are the functions performed by bynet?
What are tpump utility limitations?
Explain the types of join supports by teradata?
What are the functions of a teradata dba?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
