My source table has  4500 records and I processed same set of data to target table. I was checking the data in ‘View data’ section of both the soruce and target tables, there  I can able to see only 1000 records, but I want to check maximum records in DI designer itself.

By default DI designer allows you to check 1000 records, here is the small tweak to view  more than 1000 records in DI designer window

Go to the Tools Menu –> Select Options –> Designer –> General –>
View data sampling size (rows): change the default parameter (1000) to 5000.

Save the jobserver settings.  Now, you can able to see max upto 5000 records  in ‘view data’  section.