How a Referential integrity is handled in Teradata?
Answer Posted / 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 |
Post New Answer View All Answers
What is a level of granularity of a fact table?
Difference between stored procedure and macro?
What do you mean by teradata sql assistant?
Explain some differences between mpp and smp?
What are the functions of a Parser?
Explain amp in teradata?
What tools would you use for that?
How do you set the session mode parameters in bteq?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Highlight a few of the important components of Teradata?
Explain vproc in teradata?
What is multi insert?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain the term 'columns' related to relational database management system?