topic Re: SQL query output and passing a default value to the output in Talend Studio

SQL query output and passing a default value to the output

Anonymous — Thu, 13 Apr 2017 20:53:37 GMT

Dear's,

I have a requirement , in which i have a sql query and i need to classified the output to default value ex:-TEST

The sql query has one column and it will fetch me 100 rows with different id's

Now once i get the output i need to pass a default value 'TEST' to that column

query is : select * from table where id<=5 , i need to pass this query and generate output as below

ex: if the query gives me 5 rows , With different values like below

My output should be

TEST

Basically i need to classify using the query .

how shall i do it using talend?

Please help will be appreciated.

Re: SQL query output and passing a default value to the output

Anonymous — Thu, 13 Apr 2017 21:26:57 GMT

Hi Ami,

It sounds like you want to mask your data. You have two ways:

1. Your mapping. A tMap will typically map the input_row.id --> out_row.id. Your mapping expression can be a constant. So out_row_id can be simply mapped to a constant "TEST".

2. You can also explore the Data Masking features available in Talend, very flexible and versatile. Watch this video for a quick demo:

https://www.youtube.com/watch?v=YTl8IgaoZv8

If you want your value to be a parameter, check how to use Context variables here:

https://help.talend.com/display/TalendOpenStudioforESBUserGuide60EN/3.4.1+How+to+define+context+variables+for+a+Job

HTH

Gene

Re: SQL query output and passing a default value to the output

TRF — Thu, 13 Apr 2017 21:34:12 GMT

Just try to replace your query by this one:

select 'TEST' as ID from table where id<=5

Regards

TRF

Re: SQL query output and passing a default value to the output

Anonymous — Fri, 14 Apr 2017 04:41:20 GMT

Thanks , was thinking on similar lines , we will try this and intimate you bro!

Re: SQL query output and passing a default value to the output

Anonymous — Fri, 14 Apr 2017 04:41:41 GMT

Thanks for the reply surely i will try out this

Re: SQL query output and passing a default value to the output

Anonymous — Fri, 14 Apr 2017 04:43:32 GMT

Dear,

I want to implement this as a incremental job ,
i want to incrementally pull data from the below query

to Take the unique ID from schema_name.table_name where ID like ‘11%’

I have never used incremental in talend .
Can you give me steps to build one job ?
Many Thanks,
Amit