It is more difficult to conduct updates and deletes on a fact table, than to simply insert new rows. If the source system handles the updates and deletes, then this is the preferable option since it is already in place. Unfortunately, however, this is not always the case. How is it possible to handle unaudited… Continue reading How is it best to handle unaudited Fact Table Updates and Deletes?
If SSIS is being used to retrieve large amounts of data from an Oracle database, the SSIS package may fail with the following error message:ORA-01652: unable to extend temp segment by 256 in tablespaceThis error basically means that Oracle could not extend the temporary segment for the required number of blocks in the user's allocated tablespace. There… Continue reading SSIS and Oracle: challenge of ‘Unable to extend temp segment’ in Oracle
It's possible to use SSIS to create a new Oracle table for you. However, there are a few 'gotchas' that it's necessary to look out for.It's possible to use the 'OLE DB Destination' adapter to insert data into Oracle. Thus, if a new Oracle table is required, it's possible to select the destination Oracle database, and use the 'New'… Continue reading Creating Oracle Tables using SSIS