I have a process that loops thru multiple csv files and I need to capture the filename as part of the input transformation, so the source data is appended with additional column called 'File_name' and populated with the name of the file. How this can be achieved in the Data Migrator flow?

Are you asking how to get the file name or how to loop?

You can add a field to the input synonym with FIELD=FILE_NAME, ALIAS=INSTANCE and that will be automatically populated with the name of the input file.

You can process multiple files using the Iterator (if all the files are ready to process) or the File Listener (if you want to process files as they arrive in a specified application directory). Both approaches are documented in the DataMigrator User's Guide.

Thank you! This is exactly what i was looking for.