Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23460 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 |
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Explain amp in teradata?
What's the difference between timestamp (0) and timestamp (6)?
What is oltp?
write lock is compatiable with which type of lock?
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
What are the main components of teradata system?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Describe primary index in teradata. And what are the available primary index types?
What are the functions involved in shared information architecture?
What is Join Index in TD and How it works?
If the table does not have duplicates then which utility you can suggest to load the data ?
Teradata 
