> Is there a limitation on the number of rows returned by the file translator?
No. The file translator simply returns blob or clob reference to the file. The texttable function will then process that into rows. Unless there is something wrong with the expectations of how it is parsing, you should see all of the rows.
Somehow I am only able to see only 47429 rows. Any pointers to debug this?
Start with the simplest case possible, just feeding the file into texttable and fully reading the results. From there you should examine the results to see if they match up to your file in the way that you expect.