Basic SCD syntax error

[Anonymous]

Hello. I am new to Talend and learning.

I am trying to do a tDBSCD component on basic customer information. I am reading from SQL server and populating back into SQL server. When I run the job I get the following error: " Incorrect syntax near 'WHERE' " , repeated a number of times. 

I included a screenshot below of the SCD setup. 

Any help in discovering the cause of this error is appreciated. 

Thank you. 

[nivedhitha · Accepted solution]

No. the surrogate key is just a column with sequential numbers in your case. source key is the is the column with which you identify which row you are referring to. It is based on that key, say the customerid you decide if any of the dimensions like name or status or class has changed. For every change you will see a new record inserted with the existing record expired  

[Anonymous]

OH! i see what you mean. it works now! thank you!