Replicate database table along with table definition

[yoxler]

We want to replace an old load logic in our data warehouse.

Current logic loads all data into staging in the data warehous along with new table definition. So if a column increases or a data type changes that is automatically fixed in the staging area. 

The load come from an Oracle and the destination is a MSSQL Server. 

is it possible to pick upp the table definition from Oracle and create a table in MSSQL? Once that is done the load can start.

Thanks

Andreas

[akumar2301]

For dynamic load transfer you could use dynamic schema

e.g. 

http://jilanisyed786.blogspot.com/2017/10/dynamic-schema-load-in-talend.html

In Oracle you have table called user_tab_cols which has basic table definition. You could use to read these and create table statement for your sql server 

[yoxler]

Thanks!

Will try it out next week and see if I can make it work.

Regards

Andreas