How to dynamically create target files based on input conditions using Transaction Control ?

You need to generate multiple flat file using an Informatica mapping based on the source data content or some other business rule; from a single data source. For example- Create separate target files and load employees in them department wise. You don't know the total number of departments. #informaticinterview #transactioncontrol #informaticascenarios