The simple answer is yes. When using RODIN CDC and ETL components together, you can achieve (near) real-time load of your data warehouse.

However, in many cases this may not be sensible to do. The limitations on real-time load are usually associated with the data itself and your business requirements, rather than the technology. When performing ETL you are often joining multiple tables, and performing validations and transformations that are dependent on data in secondary tables. Sometimes that secondary data is not yet available or in a usable form at the time of the transaction. Validation may fail or calculations may be incorrect as a result.

Use real-time load when it makes sense to do so. Expect that in some cases, the traditional batch ETL (often at end of day) is the best approach.