Hi Dmiller,
Please find below output from script snap and mapper output. Mapper output has two update statements same which is incorrect, it has to be same like script.
Script Snap:
“query”: “update iods_staging.stg_sf_account_dim_institution set record_inserted = true;”
“query”: “update iods_staging.stg_sf_accountdistict_dim_institution set record_inserted = true;”
“query”: “update iods_staging.stg_sf_recordtype_dim_institution set record_inserted = true;”
Mapper Output:
“query”
“update iods_staging.stg_sf_account_dim_institution set record_inserted = true;”
“update iods_staging.stg_sf_recordtype_dim_institution set record_inserted = true;”
“update iods_staging.stg_sf_recordtype_dim_institution set record_inserted = true;”
Thanks
Aditya
Is there a reason you need the Mapper after the Script Snap? Do you plan to modify other information?
If so and there are items like query that should not be modified, then select the Pass through option and don’t specify them in the mapping table.
Hi Dmiller,
In my real mapping I am not using mapper after script, mapper is used to show the output after validation complete.
Thanks
Aditya
