Hi @rkapoor , I later fount that I can increase the " IN " clause limit (Under where clause) from default 1000 so more records are queried at once.
@Sashankbongu are you reading multiple files via the Dynamic Input? Does all the data follow the same template ie. columns?
No @rkapoor its just one input file that connects to Dynamic Input (Netezza) .
A better screenshot added