The SCD executable should be present under <installation home>/ficdb/bin directory. The file name is scd.
The user executing the SCD component should have execute rights on the file mentioned as prerequisite in Executing the SCD Component.
The setup tables accessed by SCD component are SYS_TBL_MASTER and SYS_STG_JOIN_MASTER.
SYS_TBL_MASTER stores the information like which is the source stage table and the target dimension tables. The source sometimes can be the database views, which can be simple or a complex view.
SYS_STG_JOIN_MASTER stores the information like which source column is mapped to which column of a target dimension table. It makes use of data base sequence to populate into surrogate key columns of dimension tables.