[resolved] I want to create a generic talend job with dynamic schema.

[Anonymous]

I am using Talend Data Fabric 6.2.1 version.
I want to create a generic talend job with below requirement:
1) Source is DB2 and Target is SQL SERVER.
2) Table name and Metadata should be same for source and Target.
3) Multiple Source tables are availble with different Metadata.
4) I know we can read dynamic schema from source table and insert same in target table, but I want to do some transformation on specific columns which are present in source table.
5) This specific column information stored in seperate reference table with columns SRC_table_name, col_for_transformation(comma seperated column names present here)

Please help.

[Anonymous · Accepted solution]

Hi,
Could you please take a look at this related forum: topic to see if it can meet your needs?
Best regards
Sabrina

[Anonymous]

Thanks Sabrina, It's work.

[Anonymous]

Hi,
Great it works. Can we consider your topic as resolved? Feel free to let us know if there is any further help we can give.
Best regards
Sabrina