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.
For dynamic load transfer you could use dynamic schema
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables