Using temporary destination tables
Once the data is in temporary tables, we can begin performing the simple conversions to start getting it into shape. The next step is to create a set of tables identical to the destination tables in the data warehouse. For example, if there exists a highly partitioned sales transactions table in the data warehouse, we […]