Java Error message

[Anonymous]

What import package are the error messages stored in for Talend?

[Anonymous]

Hi, Kwags300
Before I have seen your another post https://community.talend.com/t5/Design-and-Development/Error-message-cannot-be-resolved-or-is-not-a-..., which is about the compile error. We suspect that something wrong with component's setting in your job but not the cause of import package. Would you mind uploading your component's setting screenshot to us in order that we can find out the issue.
Best regards
Sabrina

[Anonymous]

xdshi,
I have attached some pictures please let me know if there is more that i can do. I keep getting different errors i have attached some of them as well. thanks!

[Anonymous]

You have to set a Surrogate Key, the error about scd_end doesn't exist comes from the Type 2 versioning column either add a scd_start and scd_end to your dimension table or change the name to the existing one.

[Anonymous]

even if i add scd_end and scd_start to the element i still get the error. as far as a surrogate key do i absolutely have to add one?

[Anonymous]

i had forgot to add this pic as well

[Anonymous]

On my side I've been getting some weird error if a surrogate key haven't been defined. So I'd say yes.
The scd_end and scd_start must be in the database table of your dimension. if they're not there, alter the table MEDISPAN_... The start and end date are required if you use type 2 SCD.

[Anonymous]

i have tried adding scd_end and scd_start to my input and i still get the Invalid column name error. I have not recieved any surrogate errors.

[Anonymous]

You don't need them in the input actually
The scd_start and scd_end have exist as column in the table on the database.

[Anonymous]

Ok i have changed things around so that scd_start and scd_end exist in the table on the database and now i am receiving this error.