What is DataWarehousing?

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > .NET

✍: Guest

A data warehouse is a collection of data gathered and organized so that it can easily by analyzed, extracted, synthesized, and otherwise be used for the purposes of further understanding the data.

2014-10-29, 2128👍, 0💬

What is indexing?
What is indexing? If we give proper indexes on a table so that any queries written against this table can run efficiently. As your data sets grow over time, SQL Server will continue to rebuild indexes and move data around as efficiently as possible. This property is known as Indexing. 2014-10-22, 2207👍, 0💬

Explain differences between server.transfer and server.execute method?
Explain differences between server.transfer and server.execute method? Answer1: server.transfer-> transefers the serverâ€™s control to the requested page given in the parameter. server.Execute-> executes the requested page from the current page itself,with no change in the address bar... 2014-10-22, 2204👍, 0💬

What is de-normalization? When do you do it and how?
What is de-normalization? When do you do it and how? De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. Itâ€™s used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be el... 2014-10-27, 2173👍, 0💬

What is referential integrity and how can we achieve it?
What is referential integrity and how can we achieve it? Referential integrity preserves the defined relationships between tables when records are entered or deleted. In SQL Server, referential integrity is based on relationships between foreign keys and primary keys or between foreign keys and uniq... 2014-10-20, 2141👍, 0💬

What is DataWarehousing?
What is DataWarehousing? A data warehouse is a collection of data gathered and organized so that it can easily by analyzed, extracted, synthesized, and otherwise be used for the purposes of further understanding the data. 2014-10-29, 2129👍, 0💬

What is job?
What is job? It can be defined as a task performed by a computer system. For example, printing a file is a job. Jobs can be performed by a single program or by a collection of programs. 2014-10-31, 2114👍, 0💬

What is OLAP?
What is OLAP? OLAP is an acronym for On Line Analytical Processing. It is an approach to quickly provide the answer to analytical queries that are dimensional in nature. 2014-10-29, 2100👍, 0💬

How do you find the error, how can you know the number of rows affected by last SQL Statement?
How do you find the error, how can you know the number of rows affected by last SQL Statement? Answer1 @@errors->give the last error occured in the current DB. Ans. select @@rowcount Answer2. Use @@ERROR which returns the error number for the last Transact-SQL statement executed fro knowing t... 2014-11-03, 2008👍, 0💬

How do we upgrade SQL Server 7.0 to 2000?
How do we upgrade SQL Server 7.0 to 2000? Run the installation of the SQL Server 2000 In the Existing Installation dialog box, click Upgrade your existing installation, and then click Next. In the Upgrade dialog box, you are prompted as to whether you want to proceed with the requested upgrade. Clic... 2014-10-31, 1973👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.