how to test my source and target data?
In my scenario,I have a source with 100 columns, In that 100 columns few columns had been changed length of datatype such as Employee_name varchar2(30) into Employee_name varchar2(150). I have been changed column length and Execute the job successfully. Now my question is how to verify data is going successfully into my target in Full load and delta load. I can not look each and every record in Source side because I have 30 millions records in source.
Could you please suggest me how to verify data is coming successfully from source to target in best way, I hope you understand my question. I am using SAP Data Service 4.2 version and source is Oracle 11g and target also Oracle 11g.