Skip to Content

Check the spelling of the referenced table and column error.

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Apr 05, 2016 at 11:19 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 05, 2016 at 07:07 AM

    Can you post the screenshot of your query ?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 05, 2016 at 07:17 AM

    Hi @Venkata Ramana Paidi

    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.

    Add comment
    10|10000 characters needed characters exceeded