1. If there are any limitations or restrictions while using this REDO SQL output format for generating INSERT / UPDATE / DELETE SQLs with image copy on a specific interval.
This is to make sure the same process can be carried out for larger sized tables.
2. Is there any limitations for the COMPRESS YES tablespace while extracting the DMLs through log analyzer.
Release : 20.0
To answer question 1
on limitations on REDO SQL.
Always ensure the datasets you create have enough space allocated to hold the data
generated.
Depending on the options selected you could need more execution time
and more space to hold the data generated.
The various options are listed here for UNDO REDO SQL.