Is there any limitation to the type of source each Database Write Strategy can take input from?

No, there is no limitation to the type of source each Database Write Strategy can take input from. However, there is a limitation in the destination. All Database Write Strategies can only work with a Database Table destination, except the Source Diff Processor, which can be used for writing data into any file format such as excel, delimited, fixed-length, etc.