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

Answer Posted / tdguy

Referential Integrity is based upon how Primary and Foreign
keys are defined. Because of this rule, a referenced column
must be a Primary Key or must be Unique and Not Null. Using
create or alter statement, FK can be created.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1775


What is real time and near real time data warehousing?

678


How you will check the version of teradata?

590


What are the different design perspectives used in teradata?

554


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3004






Comment whether bottleneck is an error or not.

625


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1671


What are the 5 phases in a multiload utility?

617


Explain the term 'database' related to relational database management system?

579


What are the various indexes in teradata? How to use them?

572


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

604


Explain the new features of teradata?

573


What is a dimension table?

610


How does hashing happens in teradata?

624


What is the primary index in teradata?

591