-
What is XMLA in SQL Server 2005
I would like to know whether it uses SOAP or XML.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is DESCRIBE command in SQL Server?
What is its purpose?How to use it?
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Importance of Surrogate Key in Data warehousing?
Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database.
-
what is the difference between SID and Global Database Name ?
SID (System Identifier) : A SID (almost) uniquely identifies an instance. Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or less; at least on Oracle 9i. The system identifier is included in the CONNECT_DATA parts of the connect descriptors in a tnsnames.ora file. The SID defaults to the database name. Global Database Name...
-