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
What is a three-tier data warehouse?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is the difference between global temporary tables and volatile temporary tables?
What is the use of stored procedures in teradata?
What is the basic syntax for teradata select statement?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the available primary index types?
What are teradata utilities?
Describe the between keyword in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the uses of client software involved in teradata?
Highlight the limitations of TPUMP Utility.
Discuss the advantages of using partitioned primary index in a query?
Explain how spool space is used.
Give the sizes of SMALLINT, BYTEINT and INTEGER.