Star Schema : Star Schema is a relational database schema for representing multimensional data. It is the simplest form of data warehouse schema that contains...
Star schema
A single fact table with N number of Dimension
Snowflake schema
Any dimensions with extended dimensions are know as snowflake schema
star schema...
You can use the ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application performan...
The sequential files (ON APPLICATION SERVER) are called datasets. They are used for file handling in SAP.
OPEN DATASET [DATASET NAME]
FOR [OUTPUT / INPUT /...
ADO.NET introduced the DataSet class to support the disconnected, distributed data-access scenarios. With DataSet, the data retrieved from the database is cache...
The DataGrid provides the means to display a group of records from the data source (for example, the first 10), and then navigate to the "page" containing the n...
Valid answers are:
• A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
• A DataSet is desig...