Can Spark Replace ETL Tool
<p>Existing process - raw structure data are copied into a staging layer of Redshift. Then use ETL tools such as Informatica, Telend to do incremental loading into Fact and Dimension table of Datamart/datawarehouse. All joins happen within database layer(ETL pushes queries into DB)
 - Can Spark replace ETL tool and do the same processing and load data into Redshift?
 - What are the advantages and disadvantages of this architecture?</p>