I have created 2 baseview(bv_studies, bv_results) of dfferent sources in Denodo.
After that, I have created one derived view(dv_final) from these baseview with Inner Join.
I am passing 2 parameters to bv_studies.
Now the problem is, while i am executing derived view(dv_final) it is showing less number of records(114 rows) than the expected number of records(149 rows).
I found the problem, when i individually executed bv_studies it returned 106100 rows whereas i checked the execution trace of derivedview(dv_final) and at there bv_studies returned 101908 rows.
Everytime the count in execution trace of derived view for that baseview is different.(Sometimes it got 101908 sometimes 98996 and sometimes 104430 etc for same parameters) and also state is ENOUGH_ROWS_RETRIEVED.
I am not using cache. i also tried with Do not use Cache option.
I am passing same paramteres while executing both the queries.
I checked in execution trace that parameters are perfectly passed in both the queries.
Can you please help me with this issue?
Thanks in Advance