Need to create tables with same structure using Dynamic columns [Source DB: SQL Server and Target DB: Oracle]

Anonymous — Wed, 26 Sep 2018 15:32:51 GMT

Hi All,

I have a scenario like, need to create tables with same structure using "Dynamic Columns" but datatypes should be different based on the target tables. We tried to using this method using same database but what to know if it is different database.

Source DB : SQL Server

Target DB : Oracle

Example:

SQL Server Table columns

Id number 50

Name string 100

Oracle Table columns

Id Integer 50

Name Varchar2 100

Can anyone please explain us, Is it possibe to achieve this?

Re: Need to create tables with same structure using Dynamic columns [Source DB: SQL Server and Target DB: Oracle]

manodwhb — Thu, 27 Sep 2018 07:59:14 GMT

@Dhanabalan_91,when you specify the dynamic it will create based on the data what are you getting and based on that target table data type will be created.

yes it is possible can you create a test job and execute ad see the required data types are coming.

topic Re: Need to create tables with same structure using Dynamic columns [Source DB: SQL Server and Target DB: Oracle] in Talend Studio

Need to create tables with same structure using Dynamic columns [Source DB: SQL Server and Target DB: Oracle]

Re: Need to create tables with same structure using Dynamic columns [Source DB: SQL Server and Target DB: Oracle]