Data Warehouse Data from different data sources is stored in a relational database for end use analysisData from different data sources is stored in a relational database for end use analysis Data is organized
Latest Answer : A process of transforming data into information and making it available to users in a timely enough manner to make a difference. ...
I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I don't see records
Latest Answer : Hyperion essbase and interactive reporting are OLAP tool ...
MSSQLServerOLAPService
Latest Answer : SQL Server Analysis Service ...
1) Webservcies Architecture was used for Service Request(what exactly does this mean?)2) Oracle Database is connected through JDBC by using Java Programming (Why Oracle database was used? )3) XML is used to handle the data and exchanging ( What data is this?)4) _Java Script is used for client side Validation ( What exactly is client side validation and is this related to XML/ data exchanging)5) Application server was J2 EE technologies( does J2EE technolgies act as App Servers or is this a programming
What are the tools used for data analysis in DHW especially where DataStage is being used as the ETL tool?
Discus two reasons why feeding data into OLAP system directly from the source operational system is not recommended