How a Referential integrity is handled in Teradata?
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 do backup and recovery in teradata?
What is a node in teradata? Explain
What are the different table types supported by teradata?
Which is more efficient group by or distinct to find duplicates?
What's the syntax of sub string?
What can be achieved by using the teradata rdbms?
What is spool space?
How is the teradata different from oracle?
Explain parsing engine in teradata?
Difference between inner join and outer join?
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .