Normally the mapping of an ETL flow is some sort of matrix where you "map" the input columns with the output columns.
E.g.: Input_Street + Input_StreetNumber = Output_Address
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP