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 set the session mode parameters in bteq?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
What are tpump utility limitations?
Where is teradata rdbms used?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
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. Rajesh my email-id: rajeshmss87@gmail.com
What is the Maximum number of volatile tables that can be created?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
What is the use of fallback?
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?
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?
What is collect statistics?