- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Issue with View in ODI
So here's some puzzle, I am not able to solve. I have a View created on Oracle DB.
The view uses sys.dbms_crypto.hash(src => to_clob(COLUMN-1||COLUMN-2||..........||COLUMN-N),TYP => 3) and also DB link.
Basically, we are trying to implement some VALIDATION logic for our dimension, we calculate HASH value when we load our dimension and then on nightly run we compare all data from source with the loaded dimension on Validation_Hash, if there is a miss-match, which implies there was a change on Source data, another case is we are missing some rows in dimension. we capture all these rows and load into staging table and process accordingly.
Now the issue is, When I Select from that View, I see no data from SQL developer, but see almost all rows in ODI.
We are on ODI 184.108.40.206.5 and on Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production.
Any idea, whats going on here.