The Multi-File Stage s9600 template provides a simple method to stage many files with the same structure. The following steps describe how to setup this component. 1. Click “create new” from the stage component page. Find s9600 and download the “File”. This file is an xls file which contains the configuration details for the Multi File Stage tasks. […]
When building SQL Server data warehouses should user-defined schemas be used? Should tables and views be prefixed? Or, maybe we should do both. After talking to a few people about this and doing a little research, one thing is clear. Deciding to use schemas and/or prefixes is much more of a personal preference than it […]
When creating a PSA component, the designer is asked to assign a value to RecordDateTime. The selected value will have implications downstream on both fact and dimension components. RecordDateTime Definition RecordDateTime is the point in time which the record is considered effective. For example; a transaction is often considered effective at this point in time […]
Even LeapFrogBI needs to take a break every once in a while… During maintenance window periods user will be redirected to this page.
Currently packages output the following detail to the ‘Output’ pane: Information: 0x4004300B at Load via OLE DB, SSIS.Pipeline: “OLE DB Destination” wrote 106886 rows. It would be nice to see the table name that is being written to in this log. Not sure if this comes from the name of the package or the subtask, […]