Dynamic source SQL query and dynamic mapping to tDBInput component

[Anonymous]

Dear Experts,

Please advise your approach on the use case.

use case: build the SQL source query dynamically from csv file and apply dynamic schema for tDBInput component.

Metadata.csv: file contains

"column name", "column data type", "length", "table name", "where condition (optional)"

Note: the number of column might increase based on the business need.

Step1: i want to read the column details and table name from .csv file

Step2: build/form a sql query

Step3: generate the schema from the same

Step3: send query to tbDBInput component and map the schema 

Thank in advance for all your advises.

I am using Talend Open Studio DI version 7.2

Tx

prithivt

[manodwhb]

With open studio,you will not have dynamic option to use dynamic schema.in enterprise edit only you will have dynamic option.

[Anonymous]

Is there any other way of workaround to achieve this like writing javacode? or ?