Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the updated features of teradata?

1046


What is TPD?

1373


Explain teradata utilities. What is multiload, fast load, tpump?

1008


What do you mean by tpt in teradata?

1021


How many codd's rules are satisfied by teradata database?

1112


What is the use of teradata system software?

1040


What are the joins in teradata?

1014


Difference between inner join and outer join?

1027


What are the primary characteristics of the Teradata.

1156


Did you write stored procedures in teradata?

1132


While creating table my dba has fallback or no fallback in his ddl. What is that?

1186


what is object level locking ? where do appear this type of locking ?

3500


Describe the between keyword in teradata?

1040


Explain how spool space is used.

1076


how do you manage the production space. what are the proactive methods you can take ?

1947