RE: On my Target, the SCD option is not available in the Attribute Mapper, only Insert. How do I get SCD to appear as an option?
SCD option is shown in the list of load type options present in the Attribute Mapper as shown below
This snapshot is related to MSSQL native dataflow.
We can choose a particular date column as SCD end by enabling the checkbox as shown below.