Hi Gurus,
we are having data flow from DSO to inventory CUBE for goods movements.From last few month some stock qty are comming as -ive which should not come.
After analysis i came to know this might be beacause of duplicates request load from dso to cube. After investigation i got the following findings:
DSO Load Date DSO Request# Cube request# Cube Load date 03.09.2012 REQU_A04QDTBAI6B4NR5K19SB9TXFV REQU_1EGC3QZD3JPJCCJTEOYHVN6H7 03.09.2012 31.08.2012 REQU_1AEO64G2FN381MKX13OVZRXXN REQU_4GVPQGKQCGFUYIRNTHAEK0TXN 31.08.2012 31.08.2012 REQU_1C9I9D10FOSWB3HLZNLQ4OZ2J 30.08.2012 REQU_8337OGNX7HZXKUIMASPH9QJRF 30.08.2012 REQU_BSJLMJDL8C7W0B1DAIHB3AK5N 30.08.2012 REQU_BSJLMJDL8C7W0B1DAIHB3AK5N REQU_084AKGXA4OLU61WUELDWLSFPN 30.08.2012
REQU_4GVPQGKQCGFUYIRNTHAEK0TXN is repeat delta which includes all 30 and 31st request from dso.
Question :
1. REQU_084AKGXA4OLU61WUELDWLSFPN in cube donot show request# REQU_BSJLMJDL8C7W0B1DAIHB3AK5N in monitor. This is only by records count i am able to identify. This case exist with some more request in cube. Why it is not showing request# fron which data is taken.?
2. Why REQU_4GVPQGKQCGFUYIRNTHAEK0TXN include data from request#REQU_BSJLMJDL8C7W0B1DAIHB3AK5N repeatedly.
Any suggestion would be helpful.
Thanks
Rishi