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

[Anonymous]

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.......

[Anonymous]

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