I'm seeking just a simple yes or now as to whether this can be done, and if so - a gentle nudge as to what approach to take.
The business problem is that our organization has used SQL Server as the data warehouse after a pretty intense ETL process that runs overnight. We recently acquired a Netezza appliance to interfact with Siebel (or Oracle BI), and I'm trying to create a process
by which there nightly copies of the DW database in SQL Server over to Netezza. All of this is simple to manually, but the requirements call me for me to create a metadata table of tables that are to be included in nightly and intra-day hourly updates.
This metadata table has the name of each table, the key data field for gettin recent transactions from Fact tables for hourly updates.
Based on input from our Netezza advisor, Netezza can handle up to six syncronous packages running at at a time. For each scheduled task, the package would look at the metadata table for a list of tables, and use sys.all_columns to build up the package
details. Fortunately, the name of the tables and fields are identitcal from SQL Server to Netezza, and I've created a .Net page that allows developers to specify new tables they've created and the corresponding key date field that creates the Netezza
DDL language to create the table and make data type translations.
View Complete Post