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?

Answered

Also, with SCD, will the ‘SCD  End’ option set a date for the selected attribute?

Beginner Asked on September 30, 2019 in Diyotta Studio.
Add Comment
2 Answer(s)
Best answer

Hi Elbert,

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.

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?

We can choose a particular date column as SCD end by enabling the checkbox as shown below.

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?

Expert Answered on September 30, 2019.
Add Comment

Thanks Navenn.  That works!!!

Beginner Answered on October 1, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.