Need to execute a batch file? Visual Basic Script? EXE? You are in luck. Use the new s9502 (Execute Process) stage component to execute any
Simple as that. LeapFrogBI Data Warehouse Automation now supports SQL Server 2017. Existing clients can upgrade their projects without writing a single line of code
Many organizations have built data warehouses successfully, and some have failed. There’s no reason at all for you to learn the hard way. In this
The field [dbo].[Precedence].[JobNotify] in theÂ LeapFrogBIÂ console databaseÂ is used by the poll job to determine which email to send and when to send it.Â The package named â€œBI_Nofity.dtsxâ€ (step 2 of the poll agent job) consumes and sets these values.Â Here’s what the values represent.
Dimensional modeling (DM) places and emphasis on the end user’s experience. The goal is to create a data model that performs well and is simple
What is a dimensional model? What is a data warehouse? This video introduces dimensional modeling while setting the stage for the series of dimensional modeling training videos to follow.
Why build a data warehouse when you can have _____. Fill in the blank with the latest marketing epiphany.
A resilient ETL process deals with data quality issues without causing a process failure while also meeting business requirements. One issue that should be anticipated
When using several of the LeapFrogBI component types, configuration information is stored in Excel. This architecture is used in cases where it is not feasible
Users can now view a visual representation of functional constraints via the Precedence Graph option.