topic Re: how to with tMap to define constants in Talend Studio

how to with tMap to define constants

Anonymous — Sat, 16 Nov 2024 14:14:52 GMT

Hello everbody,

I'm in front off a problem that I don't find how to solve to: I'm fetchning from an oracle database a field value. this value must be updated in an mysql database throw an update with two constants in a where row: UPDATE my_table SET my_field = oraclevalue WHERE field = 'firstField' AND secondField = 'secondField';
So my batch is based like the following one:

But from and to field are not variables but must be static values. How can I define their values ? Does I need to update the model? Does I need to update job to fetch the row matching from Mysql Database server and update it?
Best

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 10:30:19 GMT

Hi,

your image is not linked

you can use a look up (small file delimited) with and dooble inner join
or create global variables in a tJava / tSetGloblavariable and use filter the output
or create two context variable and use filteron the output.

some idea

Jeremie

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 10:37:45 GMT

If you are using external image provider you may block out people from helping you. Some companies have extreme restrictive firewall rules. I can not get your picture if you don?t attach them to your post.
If you need a constant value you can use a global variable. A global variable, you can set from any place in your job (like with tPrejob) and then use in your tMap. I?m usually using a context Variable for global Variables because I like the CTRL+Space functionality.

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 10:45:36 GMT

please accept my apologises for picture, I have post a bad link url.

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 11:06:54 GMT

Hello,
thanks for your feedback.
So I have add a t_SetGlobalVar with two variables: Var1 with value firstField, Var2 with value secondField.
But I'm sorry but can't found how to use them in t_Map?

Best regards

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 11:19:28 GMT

You can use with ctrl+space in the expression builder (clic on the ...)

jeremie

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 12:52:33 GMT

hello,
thanks for yours feedback.
So I have used them like this, but I'm not sure that syntax is wrong because CTRL+space doesn't give me my variables in list.
The job contains now a t_SetGlobalVar which have two variables definitions.

In My Map, I have update the variables with CTRL+Space

But when I run job, I have an error that mapping fields cannot be null.
So, My mapping is wrong, I suppose that my variables declarations is wrong, but I can't see why.
Does someone can help a newbie?
Best regards

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 13:30:49 GMT

I don't no, I think it's the schema of your data
Perhaps put an onsubjobOk after the tSetGlobalVariables

Jeremie

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 13:55:12 GMT

As I said, if you don?t attach the picture to the post, I will not be able see them. If variables are not available, then you did not declare them before.

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 15:29:02 GMT

Well,
I have put a subjobok on the variable declaration, but variables are always unavailable in the tMap.
Here's a screenshot.

Re: how to with tMap to define constants

Anonymous — Mon, 01 Sep 2008 17:04:13 GMT

When I was talking about the CTRL+Space I?m talking about variables declared in the Contexts (second tab, between Job and Component). Did you declare your variables there?
Using context variables is only one way to deal with the situation but it is the way with the CTRL+Space.

Re: how to with tMap to define constants

Anonymous — Tue, 02 Sep 2008 13:47:43 GMT

Hello,
well I've tried this way too. I have defined in a conversion 1.0 context variable in left menu two variables, FROM and TO. But in this case too, I can"t see them in ctrl+space context.

Perhaps could you post me a screenshot on the way to define theses variables, I'm sure I'm passed next something ...
Best regards,

Re: how to with tMap to define constants

Anonymous — Tue, 02 Sep 2008 19:35:47 GMT

Re: how to with tMap to define constants

Anonymous — Wed, 03 Sep 2008 08:23:08 GMT

really thanks you for your help
just one last question: what is the difference between global variables defined in t_globalvar, context, and these kind of variables?

Re: how to with tMap to define constants

Anonymous — Wed, 03 Sep 2008 08:44:45 GMT

Hi,

in t_globalvar you define global variable for the job
in context you can create differente situation (prod,dev) with different value for the context variable. When you generate scriptjob you can choose the context (and the values of the context variable) to execute the job on the server.
After you can use "implicite tConextLoad" in the wiev job>extra : we load values of context variable from a files or data base (key;value)
For me, It's the unique interacrtion between user and job script on the server.

best regards

jeremie