Robust Import Set Transformers

[HS7]

Hi

What is the difference between the normal method of importing using a transformation map and Robust Import Set Transformers?

Do I need to define an import set table for Robust Import Set Transformers?

Thanks in advance.

[Pratiksha]

The normal import method is suitable for regular tables, while Robust Import Set Transformers are recommended for CMDB imports for better performance and handling complex data.

[HS7]

Thank you Pratiksha. 

Could you please explain specifically why  Robust Import Set Transformers is recommended?

[Pratiksha]

With transform maps, if you want data from the source table to go to three different target tables, you must create three separate transform maps. Each transform map parses the data separately, which results in three separate read operations. By contrast, the 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.