Do you find any difficulty while working with flat files as source and target?

Yes, there are difficulties I found while working with flat files some of them are:

1. We can’t use SQL override in flat files instead of that we have to use transformations.
2. testing the flat files is a very uninteresting job
3. We need to specify the correct path in the session and mention whether that file is ‘direct’ or ‘indirect. Keep that file in the exact path which we have specified in the session and we have to keep the file in the exact path as mentioned in the session.
4. If we miss the link to any column of the target, then all the data will be placed in the wrong fields. That missed column won’t exist in the target data file.