I'm trying to see the table contents of a view in DB connect. It only returns back 20 records. Is there any way to change it to show all the records that are present in the view. I'm trying to figure out some missing data in my ODS and CUBE.
When I see the view in SQL, it does show that the records are present and the total number of records as 100 (just a arbitary figure). When i check my ODS, it does show that 100 records were transferred, but when i do a check for some specific data, it fails to show it and i cannot get it when i run my query.