How a Referential integrity is handled in Teradata?
- 5 Answers
- 22536 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 |
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
what is sysdba and sysdbc ? which has high priority ?
How do you Generate Sequence in Teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is the syntax for case when statement?
Define views in teradata with general syntax.
Syntax for case when statement?
Can we load a Multi set table using MLOAD?
How do you create a table with an existing structure of another table with data and with no data?
How to eliminate product joins in a teradata sql query?
How do you set the session mode parameters in bteq?
Teradata 
