what is meant by referential integrity

[Former Member]

hi

what is meant by referential integrity

[Former Member]

Hi,

Referential integrity is the property that guarantees that values from one column depend on values from another column. This property is enforced through integrity constraints.

If you set this flag a check for referential integrity is performed for this InfoObject, against the master data table or ODS object. The InfoObject is checked for valid characteristic values.

It is used when v r doing Flexi update...

Prerequisites for checking for referential integrity:

Data is updated flexibly

You have activated error handling in the BW scheduler (Tab page Update)

On the Update tab page in the BW scheduler, you have selected the option Always update data, even when no master data exists for the data.

send ur id, i will send u screen shot of ref.integrity

regards

reena

[satykumar]

Hi,

Referential integrity in a relational database is consistency between coupled tables. Referential integrity is usually enforced by the combination of a primary key or candidate key (alternate key) and a foreign key. For referential integrity to hold, any field in a table that is declared a foreign key can contain only values from a parent table's primary key or a candidate key. For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity. The relational database management system (RDBMS) enforces referential integrity, normally either by deleting the foreign key rows as well to maintain integrity, or by returning an error and not performing the delete. Which method is used would be defined by the definition of the referential integrity constraint.

Regards,

Satyendra