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 |
What is the difference between fastload and multiload?
Explain the teradata primary index mechanics in detail with a diagram.
What are the updated features of teradata?
What is node? How many nodes and amps used in your previous project?
What is the use of stored procedures in teradata?
Why do Hash joins usually perform better than Merge Joins?
What is the difference between union and union all in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is smp and mpp platforms?
What are the functions performed by bynet?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .