Interested to Buy Any Domain ? << Click Here >> for more details...
How a Referential integrity is handled in Teradata?
- 5 Answers
- 23687 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 |
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
what is identity columns in TD?
Why Multiload does not supports USI and supports NUSI?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
What are the joins in teradata and how many types of joins are there in teradata?
What is FILLER command in Teradata?
plz explain parlla distribution and subtable concept in teradata
What is the difference between union and union all in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
In BTEQ, how are the session-mode parameters being set?
What is teradata? What are some primary characteristics of teradata?
Teradata 
