We are using Teradata Fastexport connection in Informatica to export data from few tables by joining them in Source Qualifier query and write to a CSV file. We have around 180 columns to pull, recently we added 2 new columns to this flow and we found that data for few of the records looks junk. We figured out those records and tried to run the SQ query only for those records, to our surprise the columns which were junk earlier now throwing us expected data.
Is there any fast export limitation to export the columns ? or any properties should be increased at Informatica level.
We are clueless on this issue, please help.