Migration Cockpit - Data Transformation Capability

Hello Experts,

I am working in a scenario wherein we have to migrate data from non-SAP to SAP S4HANA 2021.

I would like to understand whether Migration Cockpit and/ or Migration Object Modeler (LTMOM) has the capability to perform complex transformation, i.e. transformations where we have to refer multiple source tables or lookup tables to find the transformed value of a source field data.

OR, we have to use SAP BODS for complex data transformation ?

Your response is highly appreciated.

Thanks in advance.

Amit