Fetching newly created column by using generic schema (without using dynamic) in Open Source

Anonymous — Mon, 02 Dec 2019 12:42:48 GMT

Hi Team,

Please, followup the scenario...

I am connecting my DB and I have a table (Employee) in my database like the following,

ID | Name

1 | AA

2 | BB

Till yesterday, it was going good. But, today, my client has added a column in the database and the ColumnName is Salary. But, I should not touch the schema, that I have already developed.

Now, the newly created column has to append with the existing data in Talend.

Hope using dynamic schema, we can solve that. But, without using it, I need to achieve it.

The output should be like this,

ID | Name | Salary

1 | AA | 1000

2 | BB | 2000

Please help me to solve this.......

Re: Fetching newly created column by using generic schema (without using dynamic) in Open Source

Anonymous — Mon, 09 Dec 2019 07:24:40 GMT

Hello,

Talend dynamic schema feature is available in talend subscription solution not open source.

You could try to add a tMap component in the flow after your t<DB>Input and then add a "Salary" column.

Best regards

Sabrina

topic Re: Fetching newly created column by using generic schema (without using dynamic) in Open Source in Talend Studio

Fetching newly created column by using generic schema (without using dynamic) in Open Source

Re: Fetching newly created column by using generic schema (without using dynamic) in Open Source