It is a Boolean value that determines whether the transformation fails when input columns designated as fixed attributes contain values different from their equivalents in the dimension table. This is equivalent to the Fail the transformation if changes are detected in a fixed attribute checkbox on the Fixed and Changing Attribute Options page of the Slowly Changing Dimension Wizard.
If we checked the check box then it will be true.
If Uncheck then it will be false.
See the demo
If we check this box and dimension attribute is differ in that case our package will be fail.
See the DimCustomer and DimCustomer_STG table.
Now running this package.
Our package gets failed.
Now we are unchecking the check box
Running this package again.
Package executed successfully.
No comments:
Post a Comment
If you have any doubt, please let me know.