What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download How to view more than 1000 records in View data section window as PDF --


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.

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*