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?