Robust Transform Engine vs Transform Maps
| Sl. No. | Transform Map | Robust import set transformers |
| 1.     | Transform maps define the mapping from imported data stored in a staging table to a single target table | The Robust Transform Engine (RTE) and the robust import set transformer separate the transform and processing functions, providing a more flexible alternative to transform maps. |
| 2.      | No such option available | The robust import set transformer allows you to extract data from a source table into an intermediary data structure.
You can transform the data as desired and then load that data to one or more target |
| 3.      | With transform maps, if you want data from the source table to go to five different target tables, you must create five separate transform maps. Each transform map parses the data separately, which results in five separate read operations. | Robust import set transformer requires only a single read operation to prepare the data for three target tables. The robust import set transformer is more efficient, especially when dealing with multiple target tables. |
| 4.      | No batch processing | Records are processed as batches to enhance performance. |
| 5.      | If your target is one table then you can go ahead with transform map | Recommended to choose robust transform map if dealing with multiple target tables. |
Want to know more about robust transform map in detail with live implementation then checkout below.
1. Robust Import Set Transformers
[…] Why we should use Robust import set transformers over transform maps […]
It has many benefits, like if you wanna migrate your data from multiple table from same excel then you can do it easily. like wise many are there. For more details you can watch my video. There i have explained benefits of robust transform map over normal TM.