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.

Answer / yedidi murty

Please go through REFI (referential integrity) definition.

Answer / har

Referential Integrity is handled using MultiLoad
It supports both soft referential Integrity(i.e degenerated dimension) and NUSI dataloading

Answer / hardeep

Can any one or Srinu explain the How TPUMP actually handles the RI?

Answer / srinu

TPUMP

Can you load multiple data files for same target table using fastload?

1 Answers  

What is the default join strategy in Teradata???

5 Answers   IBM,

How do you create tables? Exact syntax, and create profiles, users in teradata?

0 Answers  

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 Answers   IBM,

What is meant by a Clique?

0 Answers  

Can we load a Multi set table using MLOAD?

2 Answers  

What is dimensional modeling?

0 Answers  

What is the use of having index on table?

0 Answers  

What interface is used to connect to windows based applications?

0 Answers  

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

2 Answers   IBM,

How to view every column and the columns contained in indexes in teradata?

0 Answers  

what is identity columns in teradata

2 Answers   Wipro,