Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23673 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yedidi murty
Please go through REFI (referential integrity) definition.
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / har
Referential Integrity is handled using MultiLoad
It supports both soft referential Integrity(i.e degenerated dimension) and NUSI dataloading
| Is This Answer Correct ? | 1 Yes | 8 No |
Answer / hardeep
Can any one or Srinu explain the How TPUMP actually handles the RI?
| Is This Answer Correct ? | 0 Yes | 8 No |
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are differences between teradata and ansi session modes in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
suppose one Cylinder split data blocks are moved from where?
What is a clique?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
The transaction exceeded the maximum number of rowhash locks allowed
How to Extract data from multiple legacy systems?
what is the difference between filter and router transmissions
which option is used to restart the fastexport script ?
Highlight the need for Performance Tuning.
How do you verify a complicated sql?
Teradata 
