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...

what is referential constraints?how do you implement RI in
teradata?

Answer Posted / yuvaevergreen

Referential constraints define a relationship between two or
more attributes between two tables. RI can be implemented
between two tables using FOREIGN KEY option in create table.
FOREIGN KEY (b) REFERENCES WITH NO CHECK OPTION tb1(a));
CHECK or NO CHECK option can be used.
CHECK option - batch RI constraint.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1008


What is dimensional modeling?

1085


What is bteq script in teradata?

1155


What do you mean by teradata intelliflex?

1107


Define views in teradata with syntax.

1078


How would you load a very large file in teradata in general?

1034


What is teradata? Also, list out some of the primary characteristics of teradata.

1060


why use references rather than pointers in the public api, particularly for arguments which are modified?

1008


How do you verify a complicated sql?

1067


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776


Mention a few of the ETL tools that come under Teradata.

1079


What do high confidence, low confidence and no confidence mean in explain plan?

1048


What do you mean by teradata intellicloud?

1038


Highlight all the modes that are present under Confidence Level.

971


How does hashing happens in teradata?

1091