In this article
The Forsta Survey Target writes data from one of the supported sources. It uses two different modes for matching rows:
- With a Forsta Survey as the source, it will use the rowguid in the response control table to match the rows.
- When a Triple-S data file is being imported to Survey Data, if the user selects responseid as the key field then it will be used.
The target will identify whether the row is a new row or an existing row. In the event the row is new, the target will create a new response with corresponding response control values. If the row exists, the target will update the values for the columns provided.
Bulk Inserts and Table Updates
To improve performance, the Forsta Survey Target will first perform a bulk insert of all the data into a temp table. The target will then identify which rows are new and which rows already exist in the survey. The process of moving (insert or update) the data from the temp table to the actual response tables completes the procedure.