Skip to Content
Former Member
Aug 26, 2009 at 10:27 AM

Issue while using views in Data services Jobs



In Data Services Job, i am trying to pull data from a view to a table. The view is pointing to the table which is in other database.

The problem is when i import the source view into data services and view the data, i found one row having wrong data. The values in that row are wrong/corrupted while the same row in the source table is having correct values

I queried the view from TOAD for that record. The values are valid.

The data is coming wrong only in Data services. Any row in that table gets corrupted, there is no specific row.

Hence while running the jobs i am getting errors.

Any idea what can be the reason of getting corrupted data in view while same view when queried from TOAD gives correct values?