Mapping from source to target Very Slow: ODI 12c

Question

Problem :

I have a view which was significantly slower earlier(fetching 50 records took 25sec) Made some code changes and performance increased by a lot( 50 records in under 7 seconds).

Now i am mapping from this view to a source table coming from same DB: ORACLE, before the code changes in view it was very slow but logically speaking after the performance increased in db, the mapping speed should have increased too, but it didn't.

ELT TOOl : ODI 
DB : PL/SQL
RECORD SIZE : 200,000
Column is present as a Number in Source and target has that column as VARCHAR

please comment if you need any more information