SQL Server Business Intelligence components
Briefly explain SQL Server 2005 Business Intelligence components?
Expert
SQL Server Integration Services : Employed for data creation and transformation. This is employed in data acquirement form a source system.
SQL Server Analysis Services : Permits data discovery employing data mining. Utilizing business logic it supports data development.
SQL Server Reporting Services : Employed for Distribution access and Data presentation.
Explain the operations that can be done with the Data Stage Director?
How are metadata keys and surrogate handled in MySQL?
Write down the employ of incremental aggregation?
Explain the term Data mart?
Specify the tasks of universe designer?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Describe briefly reusable transformations?
Briefly explain continuous and discrete data in data mining?
What demerits of ODBC does OLE DB overcome?
Identify those statements are true about a foreign key?
18,76,764
1939800 Asked
3,689
Active Tutors
1412793
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!