Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23354 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 |
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
How to load specific no.of records using bteq, or fastload,or multiload
What is a sparse index?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Comment whether bottleneck is an error or not.
how can we analyze the locks ?
How is MLOAD Teradata Server restarted after execution?
How many macros we can create inside a macro
Why are oltp database designs not generally a good idea for a data warehouse?
What are some commonly used bteq scripts?
Difference between multiload and tpump?
What is meant by a Highest Cost Plan?
Teradata 
