We have a running Informatica export; which, with the use of 'Transaction Control' transformation generates multiple files based on a flag condition. We want convert this Informatica Extract to TPT export.
This should generate multiple files based on a date.
For eg: All rows having date '2017-01-15' should be exported in one file;
All rows having date '2017-01-16' should be exported in second file;
All rows having date '2017-01-17' should be exported in third file;
and so on..
Is there a way to do this using TPT?
Please Note: The dates are not fixed. It changes for every export.