I'm working with SAP NetWeaver BW 7.3 and for the first time, I have loaded from Source System DB Connect. I have created a DataSource and pulled all records and found 8,136,559 records in PSA. When I designed and created DSO with Key Fields 0CALDAY, Item No and Company Code, it has transferred records about 8,136,559 and added records about 12,534 only. Similarly following InfoCube has about 12,534 records into its Fact table. When I tried to reconcile the data/records with source DBMS for a month, the records/data could not matched?
1. What could be the reason behind the issue? why I am unable to load the records/data correctly?
2. Have I not mentioned the Key Fields of DSO in a correct manner?
3. Is it possible to load the records/data into DSO without giving any field as Key Fields?
4. How should I resolve this issue?
5. Is it could be of DSO Overwrite and summation function utilization if yes, then how to utilize it?