1.

What is the surrogate key?

Answer»

It is an artificially generated key which is useful when the RECORDS don’t have any natural key. And not all tables need surrogate keys. The MAIN REASON to use them is they can assure that they act as unique and are represented by an auto-incrementing ID.

15. Explain The FLOW Of Creating A Cube?

Follow these steps to create a cube in SQL Server-

  • First Data Source should be created
  • Then create a Data Source View.
  • Specify Dimensions
  • Create a Cube (Cube name, type, and database type should be unique )
  • After DEPLOYING, process the cube.


Discussion

No Comment Found

Related InterviewSolutions