Load database tables (insert or Update) without specifying the schema or using dynamic schema

[radh_infy]

Hi All,

I want to create a job to load any database table with the same job, the source and target schemas are in sync.

How can i acheive the insert or update option without specifying the table schema.

I want to load the tables dynamically, i.e by specifying the source and target tables name the data should be inserted if unique else updated.

Please let me know the approach to create the design