on 04-05-2016 6:12 AM
Hi ,
I am implementing the SCD 2 on employee table. While executing the job it is throwing the below error. But it is not showing which field spelling is wrong or not existed. It is showing just Column <> only.
SESSION JOB_IU_CIVIL_D_EMPLOYEES_SCD|DATAFLOW DF_IU_CIVIL_D_EMPLOYEES_SCD|STATEMENT <GUID::'04babb3f-f9f6-4251-a5df-c0c5cb2bbda4' QUERY TCConvert_1>
Column <> was not found in table <QT_GET>. Check the spelling of the referenced table and column and ensure that the table exists and such a column exists in the table.
Please help me to resolve this issue.
Thanks & Regards,
Ramana.
I think somehow by mistakenly I removed the natural key from the QT_GET output schema after table comparison transform mapping . Due to this, I was facing the issue. Now that issue got resolved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In some cases the Data Services is having the Case Sensitive Issue with the column names. Can you please check if you are using the source as Template Table. Check the Template Table Target in the previous Dataflow and Update the column name to CAPITALS or based on your Final Target Table Structure.
Regards,
Akhilesh Kiran.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The Primary & Compare Column Field names in the Table Comparison need to be same. Or else you will get error.
In the below STOREKEY is the column from Source and this is like STORE_KEY in the Target Table. Rename the filed in the Query Transform as same structure in the Target Table before any TC.
Regards,
Akhilesh Kiran.
Can you post the screenshot of your query ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.