Question : I’m new to DW/BI, and this seems like a pretty basic question, but I can’t seem to find […]
Tag: business-intelligence
For a standby workload of long running analytical queries, is it better to turn on hot_standby_feedback or set max_standby_*_delay settings to -1?
Question : When spinning up a hot standby server specifically for BI/Analytics purposes where long running queries may be common, […]
Import data into MySQL using Talend Open Studio
Question : I have been trying to import CSV data about 60 MB; it contains about 400,000 rows, which should […]
Business Intelligence Development Studio installation for Visual studio 2010 problem
Question : I want to install Business Intelligence Development Studio for doing report development in Visual Studio 2010, however in […]
Daily snapshot fact table
Question : I have a list of products per costumer. Costumers can delete or add products to their list. I […]
Chart creation in BIDS 2008
Question : Due to low reputation point i am not able to include the picture. I am trying to make […]
What are Measures and Dimensions in Cubes
Question : I’m very new to Microsoft Sql Server Business Intelligence and Analysis Service(but I’m programming for years with SQL […]
SAP BO Freehand SQL date formatting (Oracle db)
Question : My original query worked perfectly via SQL Developer: select * from [table] where DT_CURRENT_DT = ’15-OCT-18′ However when […]
SQL Server + Microsoft Business Intelligence — free version or online learning environment?
Question : I have some experience writing queries and stored procedures in SQL server. I would like to learn how […]
Review Technical ETL process for knowledge management
Question : I’m looking for source code and all related component/material to review technical ETL process between source database and […]