Support for having reusable ETL Logic

We are trying to redesign our existing ETLs (Magic ETL) whereby we want to have two identical sets of ETLs one for Full Load and another for incremental Load. Since the ETL is complex and there are number of ETLS that will adapt same pattern, we would like a functionality in Magic ETL where we can store entire Business Logic have a reusable block and finally use that at multiple ETLs wherever they are required.

OR

Have a common ETL but change input and output datasets dynamically.

Effectively we want to have a Full Load ETL (working every month) and incremental Load will have different frequency of 10-15 mins.

1
1 votes

Active · Last Updated