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

What is a three-tier data warehouse?

0 Answers  

What is the difference between fastload and multiload? Which one is faster?

0 Answers  

What are the different functions included in the server software?

0 Answers  

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,

what is identity columns in TD?

2 Answers   Wipro,

Explain teradata architecture?

0 Answers  

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers  

Why FLOAD does not support multiset tables??

3 Answers   TCS, Tesco,

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  

What are some primary characteristics of teradata?

0 Answers  

Hash collision?

3 Answers   Satyam,

Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,