As said ...when the values from source will get loaded and if this check box is checked then it will check each values coming from the source to the values already stored in the master data table and will give an error if master data is no already loded.
Should not use it ever if you want the data loads to happen properly or it the data loads will fail if even one of the value is not found.
Hi Tarak & Ajeet,
Thank you so Much for helping me understand "Integrity".
It would be much clearer to me if you give me a small example with data.
I am very New to BI, so a business example would help me relate things in a much clearer way.
Thank you so much once again,
I will have all Customer numbers coming from R/3 to 0Customer....
If I am getting a transaction from non R/3 system...if in case that non-SAP system is having a Customer who is not defined in SAP ...... when you are loading data from non-SAP to BW you have to check Ref-Intg in transformations to omit records with a customer that is not there in 0Customer....