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

[Anonymous]

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?

[manodwhb]

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