Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2020-03-03 04:15 PM

Basic SCD syntax error

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. 

Labels (3)
Labels
247 Views
0 Likes
1 Solution

Accepted Solutions
nivedhitha
Creator III
Creator III
‎2020-03-05 10:18 AM

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  

View solution in original post

247 Views
0 Likes
11 Replies
nivedhitha
Creator III
Creator III
‎2020-03-03 04:32 PM

@kwahl, Is it the tDBInput or the scd component that is giving the error?

Can you provide screenshots(the configuration section) of both the component?

190 Views
0 Likes
Anonymous
Not applicable
‎2020-03-03 05:27 PM
Author

tDBSCD is the component with the error


Screenshot 2020-03-03 at 15.27.05.png
Screenshot 2020-03-03 at 15.26.51.png
190 Views
0 Likes
nivedhitha
Creator III
Creator III
‎2020-03-04 04:52 PM

@kwahl , Can you also ensure the below columns (start and end) actually exist in your target table(the scd-2 table)?0683p000009M9wf.png

 

190 Views
0 Likes
Anonymous
Not applicable
‎2020-03-04 04:56 PM
Author

screenshot below of table from ssms

[image: Screenshot 2020-03-04 at 14.53.34.png]

190 Views
0 Likes
Anonymous
Not applicable
‎2020-03-04 04:57 PM
Author

oops, can't insert photo from email. 

 

0683p000009M9uG.png

 

190 Views
0 Likes
manodwhb
Champion II
Champion II
‎2020-03-04 10:52 PM

@kwahl , can you share the configuration of tDBSCD component?

 

190 Views
0 Likes
Anonymous
Not applicable
‎2020-03-05 09:57 AM
Author

0683p000009M9xi.png

190 Views
0 Likes
nivedhitha
Creator III
Creator III
‎2020-03-05 10:11 AM

@kwahl ,

The issue is there are no source keys mentioned. There has to be a key field on which a lookup will be made to see if any of the dimensions have changed. 

Looking at your table I'm guessing customerid might be your key

190 Views
0 Likes
Anonymous
Not applicable
‎2020-03-05 10:14 AM
Author

is a 'source key' synonymous with 'surrogate key'?
190 Views
0 Likes