Problem when Loading dimension from an ODS table

[Anonymous]

Hello folks, I am new with Talend and I have faced a problem when I was trying to load my dimension from an ODS table. So  I am using Talend open studio Version: 6.3.0. 

You can find bellow a screenshot from my job, my t_map configuration and the data inside my ODS table.

Thanks for your help in advance !

[cterenzi · Accepted solution]

The error "Invalid escape sequence" usually occurs when you have a String containing a "\" in a component setting.  See if one of the settings in your database output component contains a "\" and if it's meant to be a literal slash, change it to "\\".

[Sid3]

Hi Mohamed

Goto "Code" Tab. Here you will see the java code. kindly mouse over the red markers and it will show you the error. share the screen shot of it.

Also share your oracle output connection properties with a scrennshot.

[Anonymous]

Thank you for your answer!

Actually I have used the same settings for configuring another TMSSqlOutput component in another job, and I didn't had any issue with that. You will find in the links bellow a screenshot of the two TMSSqlOutput components configuration and the one for source code error.

Links:

1-Data Warehouse TMSSqlOutput configuration component (the one with the error) : http://hpics.li/67495cf

2- ODS  TMSSqlOutput configuration component : http://hpics.li/fd30b83

3- The source code error : http://hpics.li/6bb32dd

[Anonymous]

Thank you for your  answer ! 

I have only find the caracter "\"  in my TMSSqlOutput component settings and I have tried to replace it with "\\" as you have suggested. That have resolved the connexion with the Output component but it seems like I have a new issue now.

Here is the string with "\" link: http://hpics.li/9360888

Here is the link with the new error: http://hpics.li/d73c8e3

[Sid3]

Share your input query

[Anonymous]

http://hpics.li/1237f8e

[Sid3]

Hi,

First execute the below query replacing the context variables in SQL server. If it works then copy the same in your input component sql query property and execute the job. Let me know your findings.

"select "+context.ODS2_Schema+".fournisseurDim.CodeFournisseur as CodeFournisseur,"+context.ODS2_Schema+".fournisseurDim.NomFournisseur as NomFournisseur from "+context.ODS2_Schema+".fournisseurDim"

Thanks,
Sid
Please like the post if it is useful
Please put to resolved if it resolves your issue.

[Anonymous]

Thank you so much ! It's working and I can finally load the dimension table.