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

When tpump is used instead of multiload?

718


What is the purpose of joins in teradata?

629


What are the things to be considered while creating secondary index?

730


Explain teradata vs. Redshift?

635


How to eliminate product joins in a teradata sql query?

692






Explain and compare pros and cons of snow flake schemas?

702


What do you mean by ttu in teradata?

654


What are the various etl tools in the market?

679


What are the functions performed by bynet?

708


What are the advantages of teradata?

688


What is a sparse index?

711


What are the steps involved after the disk manager passes the request?

683


What is the difference between teradata and oracle?

656


What is the difference between fastload and multiload?

896


Where is teradata rdbms used?

750